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

Line 476: FROM per_org_structure_elements pose

472: paa.organization_id IN
473: (
474: (
475: SELECT pose.organization_id_child
476: FROM per_org_structure_elements pose
477: WHERE pose.org_structure_version_id = posv.org_structure_version_id
478: START WITH pose.organization_id_parent = c_org_id
479: CONNECT BY PRIOR organization_id_child = organization_id_parent
480: )

Line 543: FROM per_org_structure_elements pose

539: )
540: AND paa.organization_id IN
541: (
542: SELECT pose.organization_id_parent
543: FROM per_org_structure_elements pose
544: WHERE posv.org_structure_version_id = pose.org_structure_version_id
545: UNION
546: SELECT pose.organization_id_child
547: FROM per_org_structure_elements pose

Line 547: FROM per_org_structure_elements pose

543: FROM per_org_structure_elements pose
544: WHERE posv.org_structure_version_id = pose.org_structure_version_id
545: UNION
546: SELECT pose.organization_id_child
547: FROM per_org_structure_elements pose
548: WHERE posv.org_structure_version_id = pose.org_structure_version_id
549: );
550: /**************************************************************************/
551: l_return_val NUMBER := 0;

Line 675: FROM per_org_structure_elements pose

671: AND hoi1.org_information3 IS NOT NULL
672: AND hou1.organization_id IN
673: (
674: SELECT pose.organization_id_parent
675: FROM per_org_structure_elements pose
676: ,per_org_structure_versions posv
677: WHERE posv.org_structure_version_id = pose.org_structure_version_id
678: AND posv.organization_structure_id = c_org_struct_id
679: AND posv.date_from <= c_start_date

Line 684: FROM per_org_structure_elements pose

680: AND nvl (posv.date_to
681: ,hr_general.end_of_time) >= c_end_date
682: UNION
683: SELECT pose.organization_id_child
684: FROM per_org_structure_elements pose
685: ,per_org_structure_versions posv
686: WHERE posv.org_structure_version_id = pose.org_structure_version_id
687: AND posv.organization_structure_id = c_org_struct_id
688: AND posv.date_from <= c_start_date

Line 705: FROM per_org_structure_elements pose

701: AND hoi2.org_information2 IS NOT NULL
702: AND hou2.organization_id IN
703: (
704: SELECT pose.organization_id_parent
705: FROM per_org_structure_elements pose
706: ,per_org_structure_versions posv
707: WHERE posv.org_structure_version_id = pose.org_structure_version_id
708: AND posv.organization_structure_id = c_org_struct_id
709: AND posv.date_from <= c_start_date

Line 714: FROM per_org_structure_elements pose

710: AND nvl (posv.date_to
711: ,hr_general.end_of_time) >= c_end_date
712: UNION
713: SELECT pose.organization_id_child
714: FROM per_org_structure_elements pose
715: ,per_org_structure_versions posv
716: WHERE posv.org_structure_version_id = pose.org_structure_version_id
717: AND posv.organization_structure_id = c_org_struct_id
718: AND posv.date_from <= c_start_date

Line 932: FROM per_org_structure_elements pose

928: paa.organization_id IN
929: (
930: (
931: SELECT pose.organization_id_child
932: FROM per_org_structure_elements pose
933: WHERE pose.org_structure_version_id = posv.org_structure_version_id
934: START WITH pose.organization_id_parent = p_org_id
935: CONNECT BY PRIOR organization_id_child = organization_id_parent
936: )

Line 1006: FROM per_org_structure_elements pose

1002: )
1003: AND paa.organization_id IN
1004: (
1005: SELECT pose.organization_id_parent
1006: FROM per_org_structure_elements pose
1007: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1008: UNION
1009: SELECT pose.organization_id_child
1010: FROM per_org_structure_elements pose

Line 1010: FROM per_org_structure_elements pose

1006: FROM per_org_structure_elements pose
1007: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1008: UNION
1009: SELECT pose.organization_id_child
1010: FROM per_org_structure_elements pose
1011: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1012: );
1013: /**************************************************************************/
1014: --Withdrawal and Regeneration

Line 1079: FROM per_org_structure_elements pose

1075: paa.organization_id IN
1076: (
1077: (
1078: SELECT pose.organization_id_child
1079: FROM per_org_structure_elements pose
1080: WHERE pose.org_structure_version_id = posv.org_structure_version_id
1081: START WITH pose.organization_id_parent = p_org_id
1082: CONNECT BY PRIOR organization_id_child = organization_id_parent
1083: )

Line 1169: FROM per_org_structure_elements pose

1165: )
1166: AND paa.organization_id IN
1167: (
1168: SELECT pose.organization_id_parent
1169: FROM per_org_structure_elements pose
1170: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1171: UNION
1172: SELECT pose.organization_id_child
1173: FROM per_org_structure_elements pose

Line 1173: FROM per_org_structure_elements pose

1169: FROM per_org_structure_elements pose
1170: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1171: UNION
1172: SELECT pose.organization_id_child
1173: FROM per_org_structure_elements pose
1174: WHERE posv.org_structure_version_id = pose.org_structure_version_id
1175: );
1176: /**************************************************************************/
1177: