eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_T4_AMEND_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 96: from pay_payroll_actions ppa

92: to_char(effective_date,'YYYY') ,
93: effective_date,
94: start_date,
95: business_group_id
96: from pay_payroll_actions ppa
97: where ppa.payroll_action_id = cp_payroll_action_id;
98:
99: ld_end_date DATE;
100: ld_start_date DATE;

Line 189: from pay_payroll_actions ppa

185: ,report_type
186: ,report_qualifier
187: ,report_category
188: -- Added for bug 10399514
189: from pay_payroll_actions ppa
190: where ppa.payroll_action_id = cp_payroll_action_id;
191:
192: ld_end_date DATE;
193: ld_start_date DATE;

Line 201: lv_report_type pay_payroll_actions.report_type%type;

197: ln_asg_set NUMBER := 0;
198: lv_sin per_all_people_f.national_identifier%TYPE;
199: lv_year VARCHAR2(4);
200: -- Variables declared for bug 10399514
201: lv_report_type pay_payroll_actions.report_type%type;
202: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
203: lv_report_cat pay_payroll_actions.report_category%type;
204: -- Variables declared for bug 10399514
205:

Line 202: lv_report_qualifier pay_payroll_actions.report_qualifier%type;

198: lv_sin per_all_people_f.national_identifier%TYPE;
199: lv_year VARCHAR2(4);
200: -- Variables declared for bug 10399514
201: lv_report_type pay_payroll_actions.report_type%type;
202: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
203: lv_report_cat pay_payroll_actions.report_category%type;
204: -- Variables declared for bug 10399514
205:
206: BEGIN

Line 203: lv_report_cat pay_payroll_actions.report_category%type;

199: lv_year VARCHAR2(4);
200: -- Variables declared for bug 10399514
201: lv_report_type pay_payroll_actions.report_type%type;
202: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
203: lv_report_cat pay_payroll_actions.report_category%type;
204: -- Variables declared for bug 10399514
205:
206: BEGIN
207: hr_utility.trace('Entered get_payroll_action_info');

Line 391: lv_report_type pay_payroll_actions.report_type%TYPE ;

387: ln_prev_asg_action_id NUMBER := 0;
388: ln_prev_assignment_id NUMBER := 0;
389: ln_prev_tax_unit_id NUMBER := 0;
390: ld_prev_effective_date DATE ;
391: lv_report_type pay_payroll_actions.report_type%TYPE ;
392: -- Variables declared for bug 10399514
393: l_person_on boolean ;
394: l_report_cat pay_payroll_actions.report_category%type;
395: l_state pay_payroll_actions.report_qualifier%type;

Line 394: l_report_cat pay_payroll_actions.report_category%type;

390: ld_prev_effective_date DATE ;
391: lv_report_type pay_payroll_actions.report_type%TYPE ;
392: -- Variables declared for bug 10399514
393: l_person_on boolean ;
394: l_report_cat pay_payroll_actions.report_category%type;
395: l_state pay_payroll_actions.report_qualifier%type;
396: l_report_format pay_report_format_mappings_f.report_format%type;
397: -- Variables declared for bug 10399514
398: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

Line 395: l_state pay_payroll_actions.report_qualifier%type;

391: lv_report_type pay_payroll_actions.report_type%TYPE ;
392: -- Variables declared for bug 10399514
393: l_person_on boolean ;
394: l_report_cat pay_payroll_actions.report_category%type;
395: l_state pay_payroll_actions.report_qualifier%type;
396: l_report_format pay_report_format_mappings_f.report_format%type;
397: -- Variables declared for bug 10399514
398: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
399:

Line 416: pay_payroll_actions ppa

412: select distinct paf.person_id
413: from hr_assignment_set_amendments asgset,
414: per_all_assignments_f paf,
415: pay_assignment_actions paa,
416: pay_payroll_actions ppa
417: where asgset.assignment_set_id = cp_asg_set
418: and asgset.include_or_exclude = 'I'
419: and paf.assignment_id = asgset.assignment_id
420: and paf.person_id between cp_start_person

Line 441: pay_payroll_actions ppa,

437: select distinct paf.person_id
438: from hr_assignment_set_amendments asgset,
439: per_all_assignments_f paf,
440: pay_assignment_actions paa,
441: pay_payroll_actions ppa,
442: pay_population_ranges ppr
443: where asgset.assignment_set_id = cp_asg_set
444: and asgset.include_or_exclude = 'I'
445: and paf.assignment_id = asgset.assignment_id

Line 470: from pay_payroll_actions ppa,

466: ,cp_effective_date in date) is
467: select ppa.report_type,
468: paa.assignment_id,
469: paa.assignment_action_id
470: from pay_payroll_actions ppa,
471: pay_assignment_actions paa
472: where paa.tax_unit_id = cp_tax_unit_id
473: and paa.action_status = 'C'
474: and ppa.payroll_action_id = paa.payroll_action_id

Line 702: token_val pay_payroll_actions.legislative_parameters%type;

698: parameter_list varchar2) return varchar2
699: is
700: start_ptr number;
701: end_ptr number;
702: token_val pay_payroll_actions.legislative_parameters%type;
703: par_value pay_payroll_actions.legislative_parameters%type;
704: begin
705:
706: token_val := name||'=';

Line 703: par_value pay_payroll_actions.legislative_parameters%type;

699: is
700: start_ptr number;
701: end_ptr number;
702: token_val pay_payroll_actions.legislative_parameters%type;
703: par_value pay_payroll_actions.legislative_parameters%type;
704: begin
705:
706: token_val := name||'=';
707: