APPS.PER_NL_WAZO_ARCHIVE dependencies on HR_GENERAL

Line 340: ,hr_general.end_of_time) >= c_end_date

336: ,per_absence_attendance_types paat
337: WHERE posv.organization_structure_id = c_org_struct_id
338: AND posv.date_from <= c_start_date
339: AND nvl (posv.date_to
340: ,hr_general.end_of_time) >= c_end_date
341: AND (
342: paa.organization_id IN
343: (
344: (

Line 386: ,hr_general.end_of_time) >= c_end_date

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

Line 549: ,hr_general.end_of_time) >= c_end_date

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

Line 558: ,hr_general.end_of_time) >= c_end_date

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

Line 579: ,hr_general.end_of_time) >= c_end_date

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

Line 588: ,hr_general.end_of_time) >= c_end_date

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

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

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

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 1176: ,hr_general.end_of_time)

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

Line 1370: ,hr_general.end_of_time);

1366: WHERE paei.assignment_id = p_assignment_id
1367: AND paei.aei_information_category = 'NL_LBR'
1368: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1369: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1370: ,hr_general.end_of_time);
1371: /**************************************************************************/
1372: /* per_phones */
1373: CURSOR csr_get_phone_no(p_assignment_id IN NUMBER
1374: , p_start_date IN DATE

Line 1387: ,hr_general.end_of_time);

1383: AND pp.parent_table = 'PER_ALL_PEOPLE_F'
1384: AND pp.phone_type = p_type
1385: AND p_start_date BETWEEN pp.date_from
1386: AND nvl (pp.date_to
1387: ,hr_general.end_of_time);
1388: /**************************************************************************/
1389: /* Sick Addresses */
1390: CURSOR csr_get_sick_addr(p_assignment_id IN NUMBER
1391: , p_start_date IN DATE) IS

Line 1424: ,hr_general.end_of_time)

1420: WHERE pad1.person_id = pad.person_id
1421: AND (
1422: p_start_date BETWEEN pad1.date_from
1423: AND nvl (pad1.date_to
1424: ,hr_general.end_of_time)
1425: OR pad1.date_from > p_start_date
1426: )
1427: );
1428: /**************************************************************************/

Line 1456: ,hr_general.end_of_time);

1452: AND pas.effective_end_date
1453: AND pad.person_id = pas.person_id
1454: AND p_start_date BETWEEN pad.date_from
1455: AND nvl (pad.date_to
1456: ,hr_general.end_of_time);
1457: /**************************************************************************/
1458: /*NL_DS_SICK_INFO - Contact Details*/
1459: CURSOR csr_get_sickness_contact (p_assignment_id IN NUMBER
1460: , p_start_date IN DATE) IS

Line 1492: ,hr_general.end_of_time

1488: /**************************************************************************/
1489: CURSOR csr_get_assignment_dates(p_assignment_id IN NUMBER) IS
1490: SELECT to_char(min (pas.effective_start_date),'YYYYMMDD') ass_start_date
1491: ,to_char(decode (max (pas.effective_end_date)
1492: ,hr_general.end_of_time
1493: ,to_date(NULL),max (pas.effective_end_date)),'YYYYMMDD') ass_end_date
1494: FROM per_all_assignments_f pas
1495: WHERE pas.assignment_id = p_assignment_id;
1496: /**************************************************************************/