APPS.PER_NL_DSRR_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 548: ,hr_general.end_of_time) >= c_end_date

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

Line 557: ,hr_general.end_of_time) >= c_end_date

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

Line 578: ,hr_general.end_of_time) >= c_end_date

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

Line 587: ,hr_general.end_of_time) >= c_end_date

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

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

791: , per_all_assignments_f paa
792: , per_all_people_f pap
793: WHERE posv.organization_structure_id = p_org_struct_id
794: AND posv.date_from <= p_end_date
795: AND nvl (posv.date_to, hr_general.end_of_time) >= p_start_date
796: AND (
797: paa.organization_id IN
798: (
799: (

Line 943: ,hr_general.end_of_time) >= p_start_date

939: , per_all_people_f pap
940: WHERE posv.organization_structure_id = p_org_struct_id
941: AND posv.date_from <= p_end_date
942: AND nvl (posv.date_to
943: ,hr_general.end_of_time) >= p_start_date
944: AND (
945: paa.organization_id IN
946: (
947: (

Line 1178: ,hr_general.end_of_time)

1174: ,per_org_structure_versions posv
1175: WHERE posv.organization_structure_id = p_org_struct_id
1176: AND p_abs_start_date BETWEEN posv.date_from
1177: AND nvl (posv.date_to
1178: ,hr_general.end_of_time)
1179: AND pas.assignment_id = p_assignment_id
1180: AND hou.organization_id = hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1181: ,pas.organization_id)
1182: AND hoi.organization_id = hou.organization_id