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_T4A_AMEND_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 74: from pay_payroll_actions ppa

70: to_char(effective_date,'YYYY') ,
71: effective_date,
72: start_date,
73: business_group_id
74: from pay_payroll_actions ppa
75: where ppa.payroll_action_id = cp_payroll_action_id;
76:
77: ld_end_date DATE;
78: ld_start_date DATE;

Line 163: from pay_payroll_actions ppa

159: ,report_type
160: ,report_qualifier
161: ,report_category
162: -- Added for bug 10399514
163: from pay_payroll_actions ppa
164: where ppa.payroll_action_id = cp_payroll_action_id;
165:
166: ld_end_date DATE;
167: ld_start_date DATE;

Line 174: lv_report_type pay_payroll_actions.report_type%type;

170: ln_person_id NUMBER := 0;
171: ln_asg_set NUMBER := 0;
172: lv_year VARCHAR2(4);
173: -- Variables declared for bug 10399514
174: lv_report_type pay_payroll_actions.report_type%type;
175: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
176: lv_report_cat pay_payroll_actions.report_category%type;
177: -- Variables declared for bug 10399514
178:

Line 175: lv_report_qualifier pay_payroll_actions.report_qualifier%type;

171: ln_asg_set NUMBER := 0;
172: lv_year VARCHAR2(4);
173: -- Variables declared for bug 10399514
174: lv_report_type pay_payroll_actions.report_type%type;
175: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
176: lv_report_cat pay_payroll_actions.report_category%type;
177: -- Variables declared for bug 10399514
178:
179: BEGIN

Line 176: lv_report_cat pay_payroll_actions.report_category%type;

172: lv_year VARCHAR2(4);
173: -- Variables declared for bug 10399514
174: lv_report_type pay_payroll_actions.report_type%type;
175: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
176: lv_report_cat pay_payroll_actions.report_category%type;
177: -- Variables declared for bug 10399514
178:
179: BEGIN
180: hr_utility.trace('Entered get_payroll_action_info');

Line 360: lv_report_type pay_payroll_actions.report_type%TYPE;

356: ln_prev_asg_action_id NUMBER := 0;
357: ln_prev_assignment_id NUMBER := 0;
358: ln_prev_tax_unit_id NUMBER := 0;
359: ld_prev_effective_date DATE;
360: lv_report_type pay_payroll_actions.report_type%TYPE;
361: -- Variables declared for bug 10399514
362: l_person_on boolean ;
363: l_report_cat pay_payroll_actions.report_category%type;
364: l_state pay_payroll_actions.report_qualifier%type;

Line 363: l_report_cat pay_payroll_actions.report_category%type;

359: ld_prev_effective_date DATE;
360: lv_report_type pay_payroll_actions.report_type%TYPE;
361: -- Variables declared for bug 10399514
362: l_person_on boolean ;
363: l_report_cat pay_payroll_actions.report_category%type;
364: l_state pay_payroll_actions.report_qualifier%type;
365: l_report_format pay_report_format_mappings_f.report_format%type;
366: -- Variables declared for bug 10399514
367: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

Line 364: l_state pay_payroll_actions.report_qualifier%type;

360: lv_report_type pay_payroll_actions.report_type%TYPE;
361: -- Variables declared for bug 10399514
362: l_person_on boolean ;
363: l_report_cat pay_payroll_actions.report_category%type;
364: l_state pay_payroll_actions.report_qualifier%type;
365: l_report_format pay_report_format_mappings_f.report_format%type;
366: -- Variables declared for bug 10399514
367: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
368:

Line 385: pay_payroll_actions ppa

381: select distinct paf.person_id
382: from hr_assignment_set_amendments asgset,
383: per_all_assignments_f paf,
384: pay_assignment_actions paa,
385: pay_payroll_actions ppa
386: where asgset.assignment_set_id = cp_asg_set
387: and asgset.include_or_exclude = 'I'
388: and paf.assignment_id = asgset.assignment_id
389: and paf.person_id between cp_start_person

Line 410: pay_payroll_actions ppa,

406: select distinct paf.person_id
407: from hr_assignment_set_amendments asgset,
408: per_all_assignments_f paf,
409: pay_assignment_actions paa,
410: pay_payroll_actions ppa,
411: pay_population_ranges ppr
412: where asgset.assignment_set_id = cp_asg_set
413: and asgset.include_or_exclude = 'I'
414: and paf.assignment_id = asgset.assignment_id

Line 439: from pay_payroll_actions ppa,

435: ,cp_effective_date in date) is
436: select ppa.report_type,
437: paa.assignment_id,
438: paa.assignment_action_id
439: from pay_payroll_actions ppa,
440: pay_assignment_actions paa
441: where paa.tax_unit_id = cp_tax_unit_id
442: and paa.action_status = 'C'
443: and ppa.business_group_id+0 = ln_business_group_id

Line 673: token_val pay_payroll_actions.legislative_parameters%type;

669: parameter_list varchar2) return varchar2
670: is
671: start_ptr number;
672: end_ptr number;
673: token_val pay_payroll_actions.legislative_parameters%type;
674: par_value pay_payroll_actions.legislative_parameters%type;
675: begin
676:
677: token_val := name||'=';

Line 674: par_value pay_payroll_actions.legislative_parameters%type;

670: is
671: start_ptr number;
672: end_ptr number;
673: token_val pay_payroll_actions.legislative_parameters%type;
674: par_value pay_payroll_actions.legislative_parameters%type;
675: begin
676:
677: token_val := name||'=';
678: