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

Line 73: leg_param pay_payroll_actions.legislative_parameters%type;

69: */
70:
71: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
72: l_payroll_id number;
73: leg_param pay_payroll_actions.legislative_parameters%type;
74: l_taxyear varchar2(100);
75: l_pre_org_id varchar2(100);
76:
77: begin

Line 83: from pay_payroll_actions ppa

79: hr_utility.trace('begining of range_cursor 1 ');
80:
81: select legislative_parameters
82: into leg_param
83: from pay_payroll_actions ppa
84: where ppa.payroll_action_id = pactid;
85:
86: l_taxyear := '''' || pay_ca_rl2_reg.get_parameter('TAX_YEAR',leg_param) || '''';
87: l_pre_org_id := '''' || pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',leg_param) || '''';

Line 92: pay_payroll_actions ppa_reg,

88:
89: sqlstr := 'select distinct to_number(paa_arch.serial_number)
90: from pay_action_information pai1,
91: pay_action_information pai2,
92: pay_payroll_actions ppa_reg,
93: pay_payroll_actions ppa_arch,
94: pay_assignment_actions paa_arch
95: where ppa_reg.payroll_action_id = :payroll_action_id
96: and pai1.action_context_type = ''PA''

Line 93: pay_payroll_actions ppa_arch,

89: sqlstr := 'select distinct to_number(paa_arch.serial_number)
90: from pay_action_information pai1,
91: pay_action_information pai2,
92: pay_payroll_actions ppa_reg,
93: pay_payroll_actions ppa_arch,
94: pay_assignment_actions paa_arch
95: where ppa_reg.payroll_action_id = :payroll_action_id
96: and pai1.action_context_type = ''PA''
97: and pai1.action_information1 = ''RL2''

Line 139: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

135: l_pre_organization_id number;
136: l_rlreg_pre_org_id varchar2(30);
137: l_effective_date date;
138: l_report_type varchar2(80);
139: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
140: lv_serial_number varchar2(30);
141: ln_arch_asgact_id number;
142: ln_arch_pact_id number;
143: lv_per_id varchar2(30);

Line 147: l_report_cat pay_payroll_actions.report_category%type;

143: lv_per_id varchar2(30);
144:
145: -- Variables declared for bug 10399514
146: l_person_on boolean ;
147: l_report_cat pay_payroll_actions.report_category%type;
148: l_state pay_payroll_actions.report_qualifier%type;
149: l_report_format pay_report_format_mappings_f.report_format%type;
150: -- Variables declared for bug 10399514
151:

Line 148: l_state pay_payroll_actions.report_qualifier%type;

144:
145: -- Variables declared for bug 10399514
146: l_person_on boolean ;
147: l_report_cat pay_payroll_actions.report_category%type;
148: l_state pay_payroll_actions.report_qualifier%type;
149: l_report_format pay_report_format_mappings_f.report_format%type;
150: -- Variables declared for bug 10399514
151:
152: l_print_term varchar2(1);

Line 156: legislative parameter of pay_payroll_actions for RL2 archiver

152: l_print_term varchar2(1);
153: l_effective_end_date date;
154:
155: /* For performance: getting all Prov Reporting Est org ids from
156: legislative parameter of pay_payroll_actions for RL2 archiver
157: for the given year within same business group.
158: */
159: cursor c_all_pres is
160: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 162: from pay_payroll_actions ppa

158: */
159: cursor c_all_pres is
160: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
161: ppa.legislative_parameters )
162: from pay_payroll_actions ppa
163: where ppa.report_type = 'RL2'
164: and ppa.report_qualifier = 'CAEOYRL2'
165: and ppa.report_category = 'ARCHIVE'
166: and ppa.effective_date = l_year_end

Line 176: from pay_payroll_actions ppa,

172: cp_assignment_id in number,
173: cp_pre_org_id in varchar2) is
174: select paa.assignment_action_id,
175: ppa.payroll_action_id
176: from pay_payroll_actions ppa,
177: pay_assignment_actions paa
178: where ppa.report_type = 'RL2'
179: and ppa.report_qualifier = 'CAEOYRL2'
180: and ppa.report_category = 'ARCHIVE'

Line 233: from pay_payroll_actions ppa,

229: cursor c_all_asg (l_year_start date,
230: l_year_end date) is
231: select distinct paa.assignment_id,
232: to_number(paa.serial_number)
233: from pay_payroll_actions ppa,
234: pay_assignment_actions paa
235: where ppa.report_type = 'RL2'
236: and ppa.report_qualifier = 'CAEOYRL2'
237: and ppa.report_category = 'ARCHIVE'

Line 256: from pay_payroll_actions ppa,

252: paa.assignment_id assignment_id
253: */
254: select distinct paa.assignment_id assignment_id,
255: to_number(paa.serial_number)
256: from pay_payroll_actions ppa,
257: pay_assignment_actions paa,
258: pay_population_ranges ppr
259: where ppa.report_type = 'RL2'
260: and ppa.report_qualifier = 'CAEOYRL2'

Line 279: from pay_payroll_actions ppa,

275: l_year_end date,
276: l_per_id varchar2) is
277: select distinct paa.assignment_id,
278: to_number(paa.serial_number)
279: from pay_payroll_actions ppa,
280: pay_assignment_actions paa
281: where ppa.report_type = 'RL2'
282: and ppa.report_qualifier = 'CAEOYRL2'
283: and ppa.report_category = 'ARCHIVE'

Line 299: from pay_payroll_actions ppa,

295: cursor c_all_asg_in_asgset(l_year_start date,
296: l_year_end date) is
297: select distinct paa.assignment_id,
298: to_number(paa.serial_number)
299: from pay_payroll_actions ppa,
300: pay_assignment_actions paa
301: where ppa.report_type = 'RL2'
302: and ppa.report_qualifier = 'CAEOYRL2'
303: and ppa.report_category = 'ARCHIVE'

Line 328: from pay_payroll_actions ppa,

324: paa.assignment_id assignment_id
325: */
326: select distinct paa.assignment_id assignment_id,
327: to_number(paa.serial_number)
328: from pay_payroll_actions ppa,
329: pay_assignment_actions paa,
330: pay_population_ranges ppr
331: where ppa.report_type = 'RL2'
332: and ppa.report_qualifier = 'CAEOYRL2'

Line 375: from pay_payroll_actions

371: l_report_cat,
372: -- Added for bug 10399514
373: l_bus_group_id,
374: l_legislative_parameters
375: from pay_payroll_actions
376: where payroll_action_id = pactid;
377:
378: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
379:

Line 794: pay_payroll_actions ppa1

790: hr_locations_all loc,
791: per_all_people_f ppf,
792: per_all_assignments_f paf,
793: pay_assignment_actions paa1,
794: pay_payroll_actions ppa1
795: where ppa1.payroll_action_id = :pactid
796: and paa1.payroll_action_id = ppa1.payroll_action_id
797: and paa1.assignment_id = paf.assignment_id
798: and paf.assignment_type = ''E''

Line 837: token_val pay_payroll_actions.legislative_parameters%type;

833: parameter_list varchar2) return varchar2
834: is
835: start_ptr number;
836: end_ptr number;
837: token_val pay_payroll_actions.legislative_parameters%type;
838: par_value pay_payroll_actions.legislative_parameters%type;
839: begin
840:
841: token_val := name||'=';

Line 838: par_value pay_payroll_actions.legislative_parameters%type;

834: is
835: start_ptr number;
836: end_ptr number;
837: token_val pay_payroll_actions.legislative_parameters%type;
838: par_value pay_payroll_actions.legislative_parameters%type;
839: begin
840:
841: token_val := name||'=';
842: