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

Line 342: FROM per_org_structure_elements pose

338: paa.organization_id IN
339: (
340: (
341: SELECT pose.organization_id_child
342: FROM per_org_structure_elements pose
343: WHERE pose.org_structure_version_id = posv.org_structure_version_id
344: START WITH pose.organization_id_parent = c_org_id
345: CONNECT BY PRIOR organization_id_child = organization_id_parent
346: )

Line 409: FROM per_org_structure_elements pose

405: )
406: AND paa.organization_id IN
407: (
408: SELECT pose.organization_id_parent
409: FROM per_org_structure_elements pose
410: WHERE posv.org_structure_version_id = pose.org_structure_version_id
411: UNION
412: SELECT pose.organization_id_child
413: FROM per_org_structure_elements pose

Line 413: FROM per_org_structure_elements pose

409: FROM per_org_structure_elements pose
410: WHERE posv.org_structure_version_id = pose.org_structure_version_id
411: UNION
412: SELECT pose.organization_id_child
413: FROM per_org_structure_elements pose
414: WHERE posv.org_structure_version_id = pose.org_structure_version_id
415: );
416: /**************************************************************************/
417: l_return_val NUMBER := 0;

Line 541: FROM per_org_structure_elements pose

537: AND hoi1.org_information3 IS NOT NULL
538: AND hou1.organization_id IN
539: (
540: SELECT pose.organization_id_parent
541: FROM per_org_structure_elements pose
542: ,per_org_structure_versions posv
543: WHERE posv.org_structure_version_id = pose.org_structure_version_id
544: AND posv.organization_structure_id = c_org_struct_id
545: AND posv.date_from <= c_start_date

Line 550: FROM per_org_structure_elements pose

546: AND nvl (posv.date_to
547: ,hr_general.end_of_time) >= c_end_date
548: UNION
549: SELECT pose.organization_id_child
550: FROM per_org_structure_elements pose
551: ,per_org_structure_versions posv
552: WHERE posv.org_structure_version_id = pose.org_structure_version_id
553: AND posv.organization_structure_id = c_org_struct_id
554: AND posv.date_from <= c_start_date

Line 571: FROM per_org_structure_elements pose

567: AND hoi2.org_information2 IS NOT NULL
568: AND hou2.organization_id IN
569: (
570: SELECT pose.organization_id_parent
571: FROM per_org_structure_elements pose
572: ,per_org_structure_versions posv
573: WHERE posv.org_structure_version_id = pose.org_structure_version_id
574: AND posv.organization_structure_id = c_org_struct_id
575: AND posv.date_from <= c_start_date

Line 580: FROM per_org_structure_elements pose

576: AND nvl (posv.date_to
577: ,hr_general.end_of_time) >= c_end_date
578: UNION
579: SELECT pose.organization_id_child
580: FROM per_org_structure_elements pose
581: ,per_org_structure_versions posv
582: WHERE posv.org_structure_version_id = pose.org_structure_version_id
583: AND posv.organization_structure_id = c_org_struct_id
584: AND posv.date_from <= c_start_date

Line 797: FROM per_org_structure_elements pose

793: paa.organization_id IN
794: (
795: (
796: SELECT pose.organization_id_child
797: FROM per_org_structure_elements pose
798: WHERE pose.org_structure_version_id = posv.org_structure_version_id
799: START WITH pose.organization_id_parent = p_org_id
800: CONNECT BY PRIOR organization_id_child = organization_id_parent
801: )

Line 871: FROM per_org_structure_elements pose

867: )
868: AND paa.organization_id IN
869: (
870: SELECT pose.organization_id_parent
871: FROM per_org_structure_elements pose
872: WHERE posv.org_structure_version_id = pose.org_structure_version_id
873: UNION
874: SELECT pose.organization_id_child
875: FROM per_org_structure_elements pose

Line 875: FROM per_org_structure_elements pose

871: FROM per_org_structure_elements pose
872: WHERE posv.org_structure_version_id = pose.org_structure_version_id
873: UNION
874: SELECT pose.organization_id_child
875: FROM per_org_structure_elements pose
876: WHERE posv.org_structure_version_id = pose.org_structure_version_id
877: );
878: /**************************************************************************/
879: --Withdrawal and Regeneration

Line 944: FROM per_org_structure_elements pose

940: paa.organization_id IN
941: (
942: (
943: SELECT pose.organization_id_child
944: FROM per_org_structure_elements pose
945: WHERE pose.org_structure_version_id = posv.org_structure_version_id
946: START WITH pose.organization_id_parent = p_org_id
947: CONNECT BY PRIOR organization_id_child = organization_id_parent
948: )

Line 1034: FROM per_org_structure_elements pose

1030: )
1031: AND paa.organization_id IN
1032: (
1033: SELECT pose.organization_id_parent
1034: FROM per_org_structure_elements pose
1035: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1036: UNION
1037: SELECT pose.organization_id_child
1038: FROM per_org_structure_elements pose

Line 1038: FROM per_org_structure_elements pose

1034: FROM per_org_structure_elements pose
1035: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1036: UNION
1037: SELECT pose.organization_id_child
1038: FROM per_org_structure_elements pose
1039: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1040: );
1041: /**************************************************************************/
1042: