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_LTSRR_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 542: FROM per_org_structure_elements pose

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

Line 551: FROM per_org_structure_elements pose

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

Line 572: FROM per_org_structure_elements pose

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

Line 581: FROM per_org_structure_elements pose

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

Line 803: FROM per_org_structure_elements pose

799: paa.organization_id IN
800: (
801: (
802: SELECT pose.organization_id_child
803: FROM per_org_structure_elements pose
804: WHERE pose.org_structure_version_id = posv.org_structure_version_id
805: START WITH pose.organization_id_parent = p_org_id
806: CONNECT BY PRIOR organization_id_child = organization_id_parent
807: )

Line 878: FROM per_org_structure_elements pose

874: )
875: AND paa.organization_id IN
876: (
877: SELECT pose.organization_id_parent
878: FROM per_org_structure_elements pose
879: WHERE posv.org_structure_version_id = pose.org_structure_version_id
880: UNION
881: SELECT pose.organization_id_child
882: FROM per_org_structure_elements pose

Line 882: FROM per_org_structure_elements pose

878: FROM per_org_structure_elements pose
879: WHERE posv.org_structure_version_id = pose.org_structure_version_id
880: UNION
881: SELECT pose.organization_id_child
882: FROM per_org_structure_elements pose
883: WHERE posv.org_structure_version_id = pose.org_structure_version_id
884: );
885: /**************************************************************************/
886: --Withdrawal and Regeneration

Line 952: FROM per_org_structure_elements pose

948: paa.organization_id IN
949: (
950: (
951: SELECT pose.organization_id_child
952: FROM per_org_structure_elements pose
953: WHERE pose.org_structure_version_id = posv.org_structure_version_id
954: START WITH pose.organization_id_parent = p_org_id
955: CONNECT BY PRIOR organization_id_child = organization_id_parent
956: )

Line 1040: FROM per_org_structure_elements pose

1036: )
1037: AND paa.organization_id IN
1038: (
1039: SELECT pose.organization_id_parent
1040: FROM per_org_structure_elements pose
1041: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1042: UNION
1043: SELECT pose.organization_id_child
1044: FROM per_org_structure_elements pose

Line 1044: FROM per_org_structure_elements pose

1040: FROM per_org_structure_elements pose
1041: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1042: UNION
1043: SELECT pose.organization_id_child
1044: FROM per_org_structure_elements pose
1045: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1046: );
1047: /**************************************************************************/
1048: