APPS.PAY_CA_EOY_T4A_AMEND_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 69: from pay_payroll_actions ppa

65: to_char(effective_date,'YYYY') ,
66: effective_date,
67: start_date,
68: business_group_id
69: from pay_payroll_actions ppa
70: where ppa.payroll_action_id = cp_payroll_action_id;
71:
72: ld_end_date DATE;
73: ld_start_date DATE;

Line 249: lv_report_type pay_payroll_actions.report_type%TYPE;

245: ln_prev_asg_action_id NUMBER := 0;
246: ln_prev_assignment_id NUMBER := 0;
247: ln_prev_tax_unit_id NUMBER := 0;
248: ld_prev_effective_date DATE;
249: lv_report_type pay_payroll_actions.report_type%TYPE;
250: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
251:
252:
253: lv_serial_number VARCHAR2(30);

Line 268: pay_payroll_actions ppa

264: select distinct paf.person_id
265: from hr_assignment_set_amendments asgset,
266: per_all_assignments_f paf,
267: pay_assignment_actions paa,
268: pay_payroll_actions ppa
269: where asgset.assignment_set_id = cp_asg_set
270: and asgset.include_or_exclude = 'I'
271: and paf.assignment_id = asgset.assignment_id
272: and paf.person_id between cp_start_person

Line 293: from pay_payroll_actions ppa,

289: ,cp_effective_date in date) is
290: select ppa.report_type,
291: paa.assignment_id,
292: paa.assignment_action_id
293: from pay_payroll_actions ppa,
294: pay_assignment_actions paa
295: where paa.tax_unit_id = cp_tax_unit_id
296: and paa.action_status = 'C'
297: and ppa.business_group_id+0 = ln_business_group_id

Line 478: token_val pay_payroll_actions.legislative_parameters%type;

474: parameter_list varchar2) return varchar2
475: is
476: start_ptr number;
477: end_ptr number;
478: token_val pay_payroll_actions.legislative_parameters%type;
479: par_value pay_payroll_actions.legislative_parameters%type;
480: begin
481:
482: token_val := name||'=';

Line 479: par_value pay_payroll_actions.legislative_parameters%type;

475: is
476: start_ptr number;
477: end_ptr number;
478: token_val pay_payroll_actions.legislative_parameters%type;
479: par_value pay_payroll_actions.legislative_parameters%type;
480: begin
481:
482: token_val := name||'=';
483: