APPS.PAY_US_ER_REARCH dependencies on PAY_PAYROLL_ACTIONS

Line 138: FROM pay_payroll_actions

134: IS
135:
136: CURSOR c_yrend_pactid is
137: SELECT payroll_action_id
138: FROM pay_payroll_actions
139: WHERE report_type = 'YREND'
140: AND action_status in ('E','C')
141: AND legislative_parameters like to_char(p_tax_unit_id)||'%'
142: AND to_char(effective_date,'YYYY') = substr(p_year,1,4);

Line 150: l_pactid pay_payroll_actions.payroll_action_id%TYPE;

146: SELECT NAME
147: FROM hr_organization_units
148: where organization_id = p_tax_unit_id;
149:
150: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
151: l_eff_date Date;
152:
153: BEGIN
154: