APPS.PAY_US_W2C_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 78: from pay_payroll_actions ppa

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

Line 148: from pay_payroll_actions ppa

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

Line 308: lv_report_type pay_payroll_actions.report_type%TYPE ;

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

Line 352: from pay_payroll_actions ppa,

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

Line 389: pay_payroll_actions ppa,

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

Line 602: token_val pay_payroll_actions.legislative_parameters%type;

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

Line 603: par_value pay_payroll_actions.legislative_parameters%type;

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