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 HR_GENERAL

Line 345: AND nvl (fnd_date.canonical_to_date (pei_information2),hr_general.end_of_time);

341: FROM per_people_extra_info
342: WHERE information_type = 'NL_DS_SICK_INFO'
343: AND person_id = c_person_id
344: AND c_effective_date BETWEEN fnd_date.canonical_to_date (pei_information1)
345: AND nvl (fnd_date.canonical_to_date (pei_information2),hr_general.end_of_time);
346: /**************************************************************************/
347: CURSOR cur_get_tml_info(c_assignment_id IN NUMBER
348: , c_effective_date IN DATE) IS
349: SELECT aei.aei_information3 temp_worker

Line 355: ,hr_general.end_of_time);

351: WHERE aei.assignment_id = c_assignment_id
352: AND aei_information_category = 'NL_TML'
353: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)
354: AND nvl (fnd_date.canonical_to_date (aei_information2)
355: ,hr_general.end_of_time);
356: /**************************************************************************/
357: CURSOR cur_get_person_id(c_assignment_id IN NUMBER) IS
358: SELECT pas.person_id
359: FROM per_all_assignments_f pas

Line 470: ,hr_general.end_of_time) >= c_end_date

466: ,per_absence_attendance_types paat
467: WHERE posv.organization_structure_id = c_org_struct_id
468: AND posv.date_from <= c_start_date
469: AND nvl (posv.date_to
470: ,hr_general.end_of_time) >= c_end_date
471: AND (
472: paa.organization_id IN
473: (
474: (

Line 517: ,hr_general.end_of_time) >= c_end_date

513: ,per_absence_attendance_types paat
514: WHERE posv.organization_structure_id = c_org_struct_id
515: AND posv.date_from <= c_start_date
516: AND nvl (posv.date_to
517: ,hr_general.end_of_time) >= c_end_date
518: AND paa.person_id = c_person_id
519: AND paa.business_group_id = c_bg_id
520: AND pap.person_id = paa.person_id
521: AND pap.business_group_id = paa.business_group_id

Line 681: ,hr_general.end_of_time) >= c_end_date

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

Line 690: ,hr_general.end_of_time) >= c_end_date

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
689: AND nvl (posv.date_to
690: ,hr_general.end_of_time) >= c_end_date
691: )
692: UNION
693: SELECT 1
694: FROM hr_organization_units hou2

Line 711: ,hr_general.end_of_time) >= c_end_date

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

Line 720: ,hr_general.end_of_time) >= c_end_date

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
719: AND nvl (posv.date_to
720: ,hr_general.end_of_time) >= c_end_date
721: )
722: );
723: /**************************************************************************/
724:

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

922: ,per_all_assignments_f paa
923: ,per_all_people_f pap
924: WHERE posv.organization_structure_id = p_org_struct_id
925: AND posv.date_from <= p_end_date
926: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date
927: AND (
928: paa.organization_id IN
929: (
930: (

Line 1073: ,hr_general.end_of_time) >= p_start_date

1069: ,per_all_people_f pap
1070: WHERE posv.organization_structure_id = p_org_struct_id
1071: AND posv.date_from <= p_end_date
1072: AND nvl (posv.date_to
1073: ,hr_general.end_of_time) >= p_start_date
1074: AND (
1075: paa.organization_id IN
1076: (
1077: (

Line 1310: ,hr_general.end_of_time)

1306: ,per_org_structure_versions posv
1307: WHERE posv.organization_structure_id = p_org_struct_id
1308: AND p_abs_start_date BETWEEN posv.date_from
1309: AND nvl (posv.date_to
1310: ,hr_general.end_of_time)
1311: AND pas.assignment_id = p_assignment_id
1312: AND hou.organization_id = hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1313: ,pas.organization_id)
1314: AND hoi.organization_id = hou.organization_id

Line 1556: ,hr_general.end_of_time);

1552: WHERE paei.assignment_id = p_assignment_id
1553: AND paei.aei_information_category = 'NL_TML'
1554: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1555: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1556: ,hr_general.end_of_time);
1557: /**************************************************************************/
1558: /* labor relation info */
1559: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER
1560: , p_start_date IN DATE) IS

Line 1569: ,hr_general.end_of_time);

1565: WHERE paei.assignment_id = p_assignment_id
1566: AND paei.aei_information_category = 'NL_LBR'
1567: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1568: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1569: ,hr_general.end_of_time);
1570: /**************************************************************************/
1571: /* per_phones */
1572: CURSOR csr_get_phone_no(p_assignment_id IN NUMBER
1573: , p_start_date IN DATE

Line 1586: ,hr_general.end_of_time);

1582: AND pp.parent_table = 'PER_ALL_PEOPLE_F'
1583: AND pp.phone_type = p_type
1584: AND p_start_date BETWEEN pp.date_from
1585: AND nvl (pp.date_to
1586: ,hr_general.end_of_time);
1587: /**************************************************************************/
1588: /* Sick Addresses */
1589: CURSOR csr_get_sick_addr(p_assignment_id IN NUMBER
1590: , p_start_date IN DATE) IS

Line 1623: ,hr_general.end_of_time)

1619: WHERE pad1.person_id = pad.person_id
1620: AND (
1621: p_start_date BETWEEN pad1.date_from
1622: AND nvl (pad1.date_to
1623: ,hr_general.end_of_time)
1624: OR pad1.date_from > p_start_date
1625: )
1626: );
1627: /**************************************************************************/

Line 1655: ,hr_general.end_of_time);

1651: AND pas.effective_end_date
1652: AND pad.person_id = pas.person_id
1653: AND p_start_date BETWEEN pad.date_from
1654: AND nvl (pad.date_to
1655: ,hr_general.end_of_time);
1656: /**************************************************************************/
1657: /*NL_DS_SICK_INFO - Contact Details*/
1658: CURSOR csr_get_sickness_contact (p_assignment_id IN NUMBER
1659: , p_start_date IN DATE) IS

Line 1728: ,hr_general.end_of_time

1724: /**************************************************************************/
1725: CURSOR csr_get_assignment_dates(p_assignment_id IN NUMBER) IS
1726: SELECT to_char(min (pas.effective_start_date),'YYYYMMDD') ass_start_date
1727: ,to_char(decode (max (pas.effective_end_date)
1728: ,hr_general.end_of_time
1729: ,to_date(NULL),max (pas.effective_end_date)),'YYYYMMDD') ass_end_date
1730: FROM per_all_assignments_f pas
1731: WHERE pas.assignment_id = p_assignment_id;
1732: /**************************************************************************/