DBA Data[Home] [Help]

APPS.PAY_FR_SCHEDULE_CALCULATION dependencies on PER_STD_HOLIDAY_ABSENCES

Line 217: from per_std_holiday_absences

213: and holiday_date between p_date_start and p_date_end;
214: --
215: cursor csr_ph_overrides is
216: select to_number(to_char(date_not_taken,'J')) day
217: from per_std_holiday_absences
218: where person_id = g_person_id
219: and date_not_taken between p_date_start and p_date_end;
220: --
221: cursor csr_ph_in_lieu is

Line 223: from per_std_holiday_absences

219: and date_not_taken between p_date_start and p_date_end;
220: --
221: cursor csr_ph_in_lieu is
222: select to_number(to_char(actual_date_taken,'J')) day
223: from per_std_holiday_absences
224: where person_id = g_person_id
225: and actual_date_taken between p_date_start and p_date_end;
226: --
227: cursor csr_absence_non_working is