APPS.PAY_FR_CPAM_PREPROCESSOR dependencies on PER_TIME_PERIODS

Line 155: FROM per_time_periods ptp, per_all_assignments_f pasg

151: ORDER BY paa.date_start ;
152:
153: CURSOR C_time_periods(p_assignment_id IN Number, p_start_date IN Date, p_end_date IN Date) IS
154: SELECT ptp.start_date, ptp.end_date
155: FROM per_time_periods ptp, per_all_assignments_f pasg
156: WHERE pasg.payroll_id = ptp.payroll_id
157: AND p_start_date between pasg.effective_start_date and pasg.effective_end_date
158: AND (ptp.start_date BETWEEN p_start_date AND p_end_date
159: OR ptp.end_date BETWEEN p_start_date AND p_end_date)

Line 321: -- Query number of per_time_periods from the payroll on the assignment

317: fnd_message.raise_error;
318: END IF;
319:
320: -- Does the absence cross a period boundary?
321: -- Query number of per_time_periods from the payroll on the assignment
322: FOR rec_time_periods IN C_time_periods(p_assignment_id, GREATEST(rec_input_values.Frm_Dt,rec_absences.date_start), LEAST(rec_input_values.To_Dt,rec_absences.date_end))
323: LOOP
324: cnt_periods := cnt_periods + 1;
325: hr_utility.trace(' Period boundaries found :'||cnt_periods);