APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 86: from pay_payroll_actions ppa

82: to_char(effective_date,'YYYY') ,
83: effective_date,
84: start_date,
85: business_group_id
86: from pay_payroll_actions ppa
87: where ppa.payroll_action_id = cp_payroll_action_id;
88:
89: ld_end_date DATE;
90: ld_start_date DATE;

Line 169: from pay_payroll_actions ppa

165: report_type,
166: report_qualifier,
167: report_category
168: -- Added for bug 10399514
169: from pay_payroll_actions ppa
170: where ppa.payroll_action_id = cp_payroll_action_id;
171:
172: ld_end_date DATE;
173: ld_start_date DATE;

Line 180: lv_report_type1 pay_payroll_actions.report_type%TYPE;

176: ln_person_id NUMBER := 0;
177: ln_asg_set NUMBER := 0;
178: lv_sin per_all_people_f.national_identifier%TYPE;
179: lv_year VARCHAR2(4);
180: lv_report_type1 pay_payroll_actions.report_type%TYPE;
181: lv_state1 pay_payroll_actions.report_qualifier%type;
182: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
183:
184: BEGIN

Line 181: lv_state1 pay_payroll_actions.report_qualifier%type;

177: ln_asg_set NUMBER := 0;
178: lv_sin per_all_people_f.national_identifier%TYPE;
179: lv_year VARCHAR2(4);
180: lv_report_type1 pay_payroll_actions.report_type%TYPE;
181: lv_state1 pay_payroll_actions.report_qualifier%type;
182: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
183:
184: BEGIN
185: hr_utility.trace('Entered get_payroll_action_info');

Line 363: lv_report_type pay_payroll_actions.report_type%TYPE ;

359: ln_asg_set NUMBER := 0 ;
360: ln_prev_asg_action_id NUMBER := 0;
361: ln_prev_assignment_id NUMBER := 0;
362: ld_prev_effective_date DATE ;
363: lv_report_type pay_payroll_actions.report_type%TYPE ;
364: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
365:
366:
367: lv_serial_number VARCHAR2(30);

Line 377: lv_report_cat pay_payroll_actions.report_category%type;

373: lv_record_name varchar2(80);
374:
375: -- Variables declared for bug 10399514
376: lv_person_on boolean ;
377: lv_report_cat pay_payroll_actions.report_category%type;
378: lv_state pay_payroll_actions.report_qualifier%type;
379: lv_report_format pay_report_format_mappings_f.report_format%type;
380: -- Variables declared for bug 10399514
381:

Line 378: lv_state pay_payroll_actions.report_qualifier%type;

374:
375: -- Variables declared for bug 10399514
376: lv_person_on boolean ;
377: lv_report_cat pay_payroll_actions.report_category%type;
378: lv_state pay_payroll_actions.report_qualifier%type;
379: lv_report_format pay_report_format_mappings_f.report_format%type;
380: -- Variables declared for bug 10399514
381:
382:

Line 390: pay_payroll_actions ppa

386: select distinct paf.person_id
387: from hr_assignment_set_amendments asgset,
388: per_all_assignments_f paf,
389: pay_assignment_actions paa,
390: pay_payroll_actions ppa
391: where
392: (pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
393: ppa.legislative_parameters) = to_char(ln_pre_org_id)
394: OR pay_ca_eoy_rl1_amend_arch.get_parameter('TRANSMITTER_PRE',

Line 421: pay_payroll_actions ppa,

417: select distinct paf.person_id
418: from hr_assignment_set_amendments asgset,
419: per_all_assignments_f paf,
420: pay_assignment_actions paa,
421: pay_payroll_actions ppa,
422: pay_population_ranges ppr
423: where
424: (pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
425: ppa.legislative_parameters) = to_char(ln_pre_org_id)

Line 461: from pay_payroll_actions ppa,

457: report_qualifier,
458: report_category,
459: -- Added for bug 10399514
460: paa.assignment_action_id
461: from pay_payroll_actions ppa,
462: pay_assignment_actions paa
463: where
464: (pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
465: ppa.legislative_parameters) = to_char(cp_pre_org_id)

Line 710: token_val pay_payroll_actions.legislative_parameters%type;

706: parameter_list varchar2) return varchar2
707: is
708: start_ptr number;
709: end_ptr number;
710: token_val pay_payroll_actions.legislative_parameters%type;
711: par_value pay_payroll_actions.legislative_parameters%type;
712: begin
713:
714: token_val := name||'=';

Line 711: par_value pay_payroll_actions.legislative_parameters%type;

707: is
708: start_ptr number;
709: end_ptr number;
710: token_val pay_payroll_actions.legislative_parameters%type;
711: par_value pay_payroll_actions.legislative_parameters%type;
712: begin
713:
714: token_val := name||'=';
715: