APPS.PQH_FR_ASSIGNMENT_API dependencies on HR_GENERAL

Line 1536: AND NVL (date_to, hr_general.end_of_time);

1532: SELECT normal_hours, normal_hours_frequency
1533: FROM pqh_corps_definitions
1534: WHERE ben_pgm_id = p_corps_id
1535: AND p_effective_date BETWEEN date_from
1536: AND NVL (date_to, hr_general.end_of_time);
1537:
1538: --
1539: CURSOR csr_old_assign_record
1540: IS

Line 1574: l_business_group_id := hr_general.get_business_group_id;

1570: l_business_group_id NUMBER;
1571:
1572: BEGIN
1573: -- getting the business group id
1574: l_business_group_id := hr_general.get_business_group_id;
1575: --
1576: OPEN csr_asg_information;
1577:
1578: FETCH csr_asg_information