Organization name need to be replaced with department name.

Summary:

Hi All,

Can some one help me on changing the Organization name instead of Department name in below query

Content (required):

In the query its is fetching old organization name and new organization name, instead i need to replace OLD Department name and NEW Department name in query.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT papf.person_number   Employee_Number,

    ppnf.first_name,

    ppnf.last_name     Employee_Name,

    hla_old.location_code  Old_Location,

    hla_new.location_code  New_Location,

    (SELECT horg.name

    FROM  hr_organization_v horg