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.PAY_FR_CPAM_PREPROCESSOR dependencies on PER_ALL_ASSIGNMENTS_F

Line 138: per_all_assignments_f pasg

134: paa_p.abs_information7)) ijss_ineligible_date
135: FROM per_absence_attendances paa,
136: per_absence_attendances paa_p,
137: per_all_people_f pap,
138: per_all_assignments_f pasg
139: WHERE pasg.person_id = pap.person_id
140: AND pap.person_id = paa.person_id
141: AND paa.abs_information1 = paa_p.absence_attendance_id(+)
142: AND p_start_date between pasg.effective_start_date and pasg.effective_end_date

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)