APPS.PSP_ENC_PRE_PROCESS dependencies on PAY_PAYROLL_ACTIONS
Line 106: SELECT max(date_earned) from pay_payroll_actions
102: -- End of changes for bug fix 3434626
103:
104: /* Cursor for selecting maximum payroll date of the payroll */
105: CURSOR payroll_date_cur IS 106: SELECT max(date_earned) from pay_payroll_actions 107: WHERE payroll_id = p_payroll_id
108: AND action_type = 'R'
109: AND action_status = 'C';
110: