APPS.PAY_US_W2C_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 81: from pay_payroll_actions ppa

77:
78: CURSOR get_eoy_info(cp_w2c_eff_date in date
79: ,cp_w2c_tax_unit_id in number) is
80: select ppa.payroll_action_id
81: from pay_payroll_actions ppa
82: where ppa.report_type = 'YREND'
83: and ppa.effective_date = cp_w2c_eff_date
84: and pay_us_w2c_arch.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
85: = cp_w2c_tax_unit_id;

Line 151: from pay_payroll_actions ppa

147: to_char(effective_date,'YYYY') ,
148: effective_date,
149: start_date,
150: business_group_id
151: from pay_payroll_actions ppa
152: where ppa.payroll_action_id = cp_payroll_action_id;
153:
154: ld_end_date DATE;
155: ld_start_date DATE;

Line 311: lv_report_type pay_payroll_actions.report_type%TYPE ;

307: ln_prev_asg_action_id NUMBER := 0;
308: ln_prev_assignment_id NUMBER := 0;
309: ln_prev_tax_unit_id NUMBER := 0;
310: ld_prev_effective_date DATE ;
311: lv_report_type pay_payroll_actions.report_type%TYPE ;
312: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
313:
314:
315: lv_serial_number VARCHAR2(30);

Line 355: from pay_payroll_actions ppa,

351: ,cp_effective_date in date
352: ,cp_start_date in date) is
353: select ppa.report_type, paa.assignment_id,
354: paa.assignment_action_id
355: from pay_payroll_actions ppa,
356: pay_assignment_actions paa,
357: per_assignments_f paf
358: where paa.assignment_id = paf.assignment_id
359: and paf.person_id = cp_person_id

Line 392: pay_payroll_actions ppa,

388: SELECT max(paa.assignment_id)
389: FROM
390: pay_assignment_actions paa,
391: per_assignments_f paf,
392: pay_payroll_actions ppa,
393: pay_action_classifications pac
394: WHERE paf.person_id = cp_person_id
395: AND paa.assignment_id = paf.assignment_id
396: and paf.primary_flag = 'Y'

Line 605: token_val pay_payroll_actions.legislative_parameters%type;

601: parameter_list varchar2) return varchar2
602: is
603: start_ptr number;
604: end_ptr number;
605: token_val pay_payroll_actions.legislative_parameters%type;
606: par_value pay_payroll_actions.legislative_parameters%type;
607: begin
608:
609: token_val := name||'=';

Line 606: par_value pay_payroll_actions.legislative_parameters%type;

602: is
603: start_ptr number;
604: end_ptr number;
605: token_val pay_payroll_actions.legislative_parameters%type;
606: par_value pay_payroll_actions.legislative_parameters%type;
607: begin
608:
609: token_val := name||'=';
610: