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_WAZO_ARCHIVE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 346: FROM per_org_structure_elements pose

342: paa.organization_id IN
343: (
344: (
345: SELECT pose.organization_id_child
346: FROM per_org_structure_elements pose
347: WHERE pose.org_structure_version_id = posv.org_structure_version_id
348: START WITH pose.organization_id_parent = c_org_id
349: CONNECT BY PRIOR organization_id_child = organization_id_parent
350: )

Line 411: FROM per_org_structure_elements pose

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

Line 415: FROM per_org_structure_elements pose

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

Line 543: FROM per_org_structure_elements pose

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

Line 552: FROM per_org_structure_elements pose

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

Line 573: FROM per_org_structure_elements pose

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

Line 582: FROM per_org_structure_elements pose

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

Line 799: FROM per_org_structure_elements pose

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

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: