APPS.PAY_CA_EOY_T4_AMEND_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 90: from pay_payroll_actions ppa

86: to_char(effective_date,'YYYY') ,
87: effective_date,
88: start_date,
89: business_group_id
90: from pay_payroll_actions ppa
91: where ppa.payroll_action_id = cp_payroll_action_id;
92:
93: ld_end_date DATE;
94: ld_start_date DATE;

Line 273: lv_report_type pay_payroll_actions.report_type%TYPE ;

269: ln_prev_asg_action_id NUMBER := 0;
270: ln_prev_assignment_id NUMBER := 0;
271: ln_prev_tax_unit_id NUMBER := 0;
272: ld_prev_effective_date DATE ;
273: lv_report_type pay_payroll_actions.report_type%TYPE ;
274: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
275:
276:
277: lv_serial_number VARCHAR2(30);

Line 292: pay_payroll_actions ppa

288: select distinct paf.person_id
289: from hr_assignment_set_amendments asgset,
290: per_all_assignments_f paf,
291: pay_assignment_actions paa,
292: pay_payroll_actions ppa
293: where asgset.assignment_set_id = cp_asg_set
294: and asgset.include_or_exclude = 'I'
295: and paf.assignment_id = asgset.assignment_id
296: and paf.person_id between cp_start_person

Line 317: from pay_payroll_actions ppa,

313: ,cp_effective_date in date) is
314: select ppa.report_type,
315: paa.assignment_id,
316: paa.assignment_action_id
317: from pay_payroll_actions ppa,
318: pay_assignment_actions paa
319: where paa.tax_unit_id = cp_tax_unit_id
320: and paa.action_status = 'C'
321: and ppa.payroll_action_id = paa.payroll_action_id

Line 496: token_val pay_payroll_actions.legislative_parameters%type;

492: parameter_list varchar2) return varchar2
493: is
494: start_ptr number;
495: end_ptr number;
496: token_val pay_payroll_actions.legislative_parameters%type;
497: par_value pay_payroll_actions.legislative_parameters%type;
498: begin
499:
500: token_val := name||'=';

Line 497: par_value pay_payroll_actions.legislative_parameters%type;

493: is
494: start_ptr number;
495: end_ptr number;
496: token_val pay_payroll_actions.legislative_parameters%type;
497: par_value pay_payroll_actions.legislative_parameters%type;
498: begin
499:
500: token_val := name||'=';
501: