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_DSRR_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 801: FROM per_org_structure_elements pose

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

Line 876: FROM per_org_structure_elements pose

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

Line 880: FROM per_org_structure_elements pose

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

Line 949: FROM per_org_structure_elements pose

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

Line 1037: FROM per_org_structure_elements pose

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

Line 1041: FROM per_org_structure_elements pose

1037: FROM per_org_structure_elements pose
1038: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1039: UNION
1040: SELECT pose.organization_id_child
1041: FROM per_org_structure_elements pose
1042: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1043: );
1044: /**************************************************************************/
1045: