APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 79: from pay_payroll_actions ppa

75: to_char(effective_date,'YYYY') ,
76: effective_date,
77: start_date,
78: business_group_id
79: from pay_payroll_actions ppa
80: where ppa.payroll_action_id = cp_payroll_action_id;
81:
82: ld_end_date DATE;
83: ld_start_date DATE;

Line 262: lv_report_type pay_payroll_actions.report_type%TYPE ;

258: ln_asg_set NUMBER := 0 ;
259: ln_prev_asg_action_id NUMBER := 0;
260: ln_prev_assignment_id NUMBER := 0;
261: ld_prev_effective_date DATE ;
262: lv_report_type pay_payroll_actions.report_type%TYPE ;
263: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
264:
265:
266: lv_serial_number VARCHAR2(30);

Line 282: pay_payroll_actions ppa

278: select distinct paf.person_id
279: from hr_assignment_set_amendments asgset,
280: per_all_assignments_f paf,
281: pay_assignment_actions paa,
282: pay_payroll_actions ppa
283: where asgset.assignment_set_id = cp_asg_set
284: and asgset.include_or_exclude = 'I'
285: and paf.assignment_id = asgset.assignment_id
286: and paf.person_id between cp_start_person

Line 306: from pay_payroll_actions ppa,

302: ,cp_effective_date in date) is
303: select ppa.report_type,
304: paa.assignment_id,
305: paa.assignment_action_id
306: from pay_payroll_actions ppa,
307: pay_assignment_actions paa
308: where to_number(paa.serial_number) = cp_person_id
309: and pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
310: ppa.legislative_parameters) = to_char(cp_pre_org_id)

Line 487: token_val pay_payroll_actions.legislative_parameters%type;

483: parameter_list varchar2) return varchar2
484: is
485: start_ptr number;
486: end_ptr number;
487: token_val pay_payroll_actions.legislative_parameters%type;
488: par_value pay_payroll_actions.legislative_parameters%type;
489: begin
490:
491: token_val := name||'=';

Line 488: par_value pay_payroll_actions.legislative_parameters%type;

484: is
485: start_ptr number;
486: end_ptr number;
487: token_val pay_payroll_actions.legislative_parameters%type;
488: par_value pay_payroll_actions.legislative_parameters%type;
489: begin
490:
491: token_val := name||'=';
492: