DBA Data[Home] [Help]

APPS.PSP_MATRIX_DRIVER_PKG dependencies on PSP_PAYROLL_CONTROLS

Line 457: FROM psp_payroll_controls ppc ,

453: CURSOR payroll_end_date_cur IS
454: SELECT max(ptp.end_date)
455: FROM per_time_periods ptp
456: WHERE (ptp.time_period_id,payroll_id) in (SELECT MAX(ppc.time_period_id),ppc.payroll_id
457: FROM psp_payroll_controls ppc ,
458: psp_payroll_lines ppl -- Introduced for Bug 4511249
459: -- WHERE ppc.payroll_id = p_payroll_id Commented for Bug 4511249
460: WHERE ppc.payroll_control_id = ppl.payroll_control_id
461: AND ppl.assignment_id = p_assignment_id