APPS.PER_NL_LTSRR_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 797: AND nvl (posv.date_to, hr_general.end_of_time) >= p_start_date

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

Line 946: ,hr_general.end_of_time) >= p_start_date

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

Line 1181: ,hr_general.end_of_time)

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

Line 1316: ,hr_general.end_of_time);

1312: WHERE paei.assignment_id = p_assignment_id
1313: AND paei.aei_information_category = 'NL_LBR'
1314: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1315: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1316: ,hr_general.end_of_time);
1317: /**************************************************************************/
1318:
1319: CURSOR csr_already_exists(p_abs_att_id NUMBER) IS
1320:

Line 1389: ,hr_general.end_of_time

1385: /**************************************************************************/
1386: CURSOR csr_get_assignment_dates(p_assignment_id IN NUMBER) IS
1387: SELECT to_char(min (pas.effective_start_date),'YYYYMMDD') ass_start_date
1388: ,to_char(decode (max (pas.effective_end_date)
1389: ,hr_general.end_of_time
1390: ,to_date(NULL),max (pas.effective_end_date)),'YYYYMMDD') ass_end_date
1391: FROM per_all_assignments_f pas
1392: WHERE pas.assignment_id = p_assignment_id;
1393: /**************************************************************************/