eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PAXRWDOH_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 123: from per_org_structure_elements a

119:
120: if start_org_id is null then
121:
122: select distinct organization_id_parent into start_org_id
123: from per_org_structure_elements a
124: ,pa_implementations b
125: ,hr_organization_information c
126: where organization_id_parent not in
127: ( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d

Line 127: ( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d

123: from per_org_structure_elements a
124: ,pa_implementations b
125: ,hr_organization_information c
126: where organization_id_parent not in
127: ( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d
128: where d.org_structure_version_id = to_number(c.org_information2)
129: )
130: and a.org_structure_version_id = to_number(c.org_information2)
131: and b.business_group_id = c.organization_id