APPS.PAY_CA_EOY_RL2_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 252: lv_report_type pay_payroll_actions.report_type%TYPE ;

248: ln_asg_set NUMBER := 0 ;
249: ln_prev_asg_action_id NUMBER := 0;
250: ln_prev_assignment_id NUMBER := 0;
251: ld_prev_effective_date DATE ;
252: lv_report_type pay_payroll_actions.report_type%TYPE ;
253: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
254:
255:
256: lv_serial_number VARCHAR2(30);

Line 272: pay_payroll_actions ppa

268: select distinct paf.person_id
269: from hr_assignment_set_amendments asgset,
270: per_all_assignments_f paf,
271: pay_assignment_actions paa,
272: pay_payroll_actions ppa
273: where asgset.assignment_set_id = cp_asg_set
274: and asgset.include_or_exclude = 'I'
275: and paf.assignment_id = asgset.assignment_id
276: and paf.person_id between cp_start_person

Line 296: from pay_payroll_actions ppa,

292: ,cp_effective_date in date) is
293: select ppa.report_type,
294: paa.assignment_id,
295: paa.assignment_action_id
296: from pay_payroll_actions ppa,
297: pay_assignment_actions paa
298: where to_number(paa.serial_number) = cp_person_id
299: and pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
300: ppa.legislative_parameters) = to_char(cp_pre_org_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: