APPS.PER_NL_LTSR_ARCHIVE dependencies on HR_GENERAL

Line 336: ,hr_general.end_of_time) >= c_end_date

332: ,per_absence_attendance_types paat
333: WHERE posv.organization_structure_id = c_org_struct_id
334: AND posv.date_from <= c_start_date
335: AND nvl (posv.date_to
336: ,hr_general.end_of_time) >= c_end_date
337: AND (
338: paa.organization_id IN
339: (
340: (

Line 383: ,hr_general.end_of_time) >= c_end_date

379: ,per_absence_attendance_types paat
380: WHERE posv.organization_structure_id = c_org_struct_id
381: AND posv.date_from <= c_start_date
382: AND nvl (posv.date_to
383: ,hr_general.end_of_time) >= c_end_date
384: AND paa.person_id = c_person_id
385: AND paa.business_group_id = c_bg_id
386: AND pap.person_id = paa.person_id
387: AND pap.business_group_id = paa.business_group_id

Line 547: ,hr_general.end_of_time) >= c_end_date

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
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

Line 556: ,hr_general.end_of_time) >= c_end_date

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
555: AND nvl (posv.date_to
556: ,hr_general.end_of_time) >= c_end_date
557: )
558: UNION
559: SELECT 1
560: FROM hr_organization_units hou2

Line 577: ,hr_general.end_of_time) >= c_end_date

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
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

Line 586: ,hr_general.end_of_time) >= c_end_date

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
585: AND nvl (posv.date_to
586: ,hr_general.end_of_time) >= c_end_date
587: )
588: );
589: /**************************************************************************/
590:

Line 791: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date

787: ,per_all_assignments_f paa
788: ,per_all_people_f pap
789: WHERE posv.organization_structure_id = p_org_struct_id
790: AND posv.date_from <= p_end_date
791: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date
792: AND (
793: paa.organization_id IN
794: (
795: (

Line 938: ,hr_general.end_of_time) >= p_start_date

934: ,per_all_people_f pap
935: WHERE posv.organization_structure_id = p_org_struct_id
936: AND posv.date_from <= p_end_date
937: AND nvl (posv.date_to
938: ,hr_general.end_of_time) >= p_start_date
939: AND (
940: paa.organization_id IN
941: (
942: (

Line 1173: ,hr_general.end_of_time)

1169: ,per_org_structure_versions posv
1170: WHERE posv.organization_structure_id = p_org_struct_id
1171: AND p_abs_start_date BETWEEN posv.date_from
1172: AND nvl (posv.date_to
1173: ,hr_general.end_of_time)
1174: AND pas.assignment_id = p_assignment_id
1175: AND hou.organization_id = hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1176: ,pas.organization_id)
1177: AND hoi.organization_id = hou.organization_id