DBA Data[Home] [Help]

APPS.PSP_ENC_CRT_XML dependencies on PAY_PAYROLL_ACTIONS

Line 124: from pay_payroll_actions

120: function last_date_earned(p_payroll_id number) return varchar2 is
121: l_date_mask varchar2(20);
122: cursor get_date_Earned is
123: select to_char(max(date_earned), l_date_mask)
124: from pay_payroll_actions
125: where payroll_id = p_payroll_id
126: and action_type = 'R'
127: and action_status = 'C';
128: l_date_earned varchar2(20);