APPS.PAY_FR_SICKNESS_CALC dependencies on HR_GENERAL

Line 847: nvl(fnd_date.canonical_to_date(pabs.abs_information7),hr_general.end_of_time) elig_dt

843: -- cursor for finding absence details
844: Cursor csr_abs_detail(c_absence_id NUMBER) IS
845: SELECT pabs.date_start abs_start_date,
846: pabs.abs_information8 ijss_cal,
847: nvl(fnd_date.canonical_to_date(pabs.abs_information7),hr_general.end_of_time) elig_dt
848: FROM per_absence_attendances pabs
849: WHERE pabs.absence_attendance_id = c_absence_id
850: AND pabs.business_group_id = p_business_group_id
851: AND pabs.abs_information_category ='FR_S';

Line 902: AND c_abs_start_date BETWEEN nvl(date_start, hr_general.start_of_time) and nvl(date_end, hr_general.end_of_time)

898: SELECT count(*)
899: FROM per_contact_relationships
900: WHERE person_id = c_person_id
901: AND business_group_id = p_business_group_id
902: AND c_abs_start_date BETWEEN nvl(date_start, hr_general.start_of_time) and nvl(date_end, hr_general.end_of_time)
903: AND dependent_flag ='Y';
904: -- Cursor defined as part of bug #2651295
905: -- for fetching boundary values of rows of UDT
906: Cursor csr_row_value(c_table_name VARCHAR2, c_effective_date DATE) IS

Line 1592: l_invalid_start_dt := hr_general.end_of_time;

1588: -- populate the invalid start date variable
1589: l_invalid_start_dt := abs_details.date_start;
1590: EXIT;
1591: ELSE
1592: l_invalid_start_dt := hr_general.end_of_time;
1593: END IF;
1594: END IF;
1595: l_prev_end_dt := abs_details.date_end;
1596: -- (b) add up the duration