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.PAY_NL_ABP_ARCHIVE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 2387: FROM per_org_structure_elements pose

2383: paa.organization_id IN
2384: (
2385: (
2386: SELECT pose.organization_id_child
2387: FROM per_org_structure_elements pose
2388: WHERE pose.org_structure_version_id = posv.org_structure_version_id
2389: CONNECT BY NOCYCLE PRIOR pose.organization_id_child = pose.organization_id_parent
2390: START WITH pose.organization_id_parent = c_org_id
2391: )

Line 2514: FROM per_org_structure_elements

2510: CURSOR csr_find_parent_id(c_org_id IN NUMBER
2511: ,c_version_id IN NUMBER
2512: ,c_bg_id IN NUMBER) IS
2513: SELECT organization_id_parent
2514: FROM per_org_structure_elements
2515: WHERE organization_id_child = c_org_id
2516: AND org_structure_version_id = c_version_id
2517: AND business_group_id = c_bg_id;
2518: --=========================================================================

Line 4566: FROM per_org_structure_elements

4562: CURSOR csr_find_parent_id(c_org_id IN NUMBER
4563: ,c_version_id IN NUMBER
4564: ,c_bg_id IN NUMBER) IS
4565: SELECT organization_id_parent
4566: FROM per_org_structure_elements
4567: WHERE organization_id_child = c_org_id
4568: AND org_structure_version_id = c_version_id
4569: AND business_group_id = c_bg_id;
4570: --=========================================================================