DBA Data[Home] [Help]

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: