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 58: leg_param pay_payroll_actions.legislative_parameters%type;

54: */
55:
56: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
57: l_payroll_id number;
58: leg_param pay_payroll_actions.legislative_parameters%type;
59: l_taxyear varchar2(100);
60: l_pre_org_id varchar2(100);
61:
62: begin

Line 68: from pay_payroll_actions ppa

64: hr_utility.trace('begining of range_cursor 1 ');
65:
66: select legislative_parameters
67: into leg_param
68: from pay_payroll_actions ppa
69: where ppa.payroll_action_id = pactid;
70:
71: l_taxyear := '''' || pay_ca_rl2_reg.get_parameter('TAX_YEAR',leg_param) || '''';
72: l_pre_org_id := '''' || pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',leg_param) || '''';

Line 77: pay_payroll_actions ppa_reg,

73:
74: sqlstr := 'select distinct to_number(paa_arch.serial_number)
75: from pay_action_information pai1,
76: pay_action_information pai2,
77: pay_payroll_actions ppa_reg,
78: pay_payroll_actions ppa_arch,
79: pay_assignment_actions paa_arch
80: where ppa_reg.payroll_action_id = :payroll_action_id
81: and pai1.action_context_type = ''PA''

Line 78: pay_payroll_actions ppa_arch,

74: sqlstr := 'select distinct to_number(paa_arch.serial_number)
75: from pay_action_information pai1,
76: pay_action_information pai2,
77: pay_payroll_actions ppa_reg,
78: pay_payroll_actions ppa_arch,
79: pay_assignment_actions paa_arch
80: where ppa_reg.payroll_action_id = :payroll_action_id
81: and pai1.action_context_type = ''PA''
82: and pai1.action_information1 = ''RL2''

Line 132: legislative parameter of pay_payroll_actions for RL2 archiver

128: lv_per_id varchar2(30);
129:
130:
131: /* For performance: getting all Prov Reporting Est org ids from
132: legislative parameter of pay_payroll_actions for RL2 archiver
133: for the given year within same business group.
134: */
135: cursor c_all_pres is
136: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 138: from pay_payroll_actions ppa

134: */
135: cursor c_all_pres is
136: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
137: ppa.legislative_parameters )
138: from pay_payroll_actions ppa
139: where ppa.report_type = 'RL2'
140: and ppa.report_qualifier = 'CAEOYRL2'
141: and ppa.report_category = 'ARCHIVE'
142: and ppa.effective_date = l_year_end

Line 152: from pay_payroll_actions ppa,

148: cp_assignment_id in number,
149: cp_pre_org_id in varchar2) is
150: select paa.assignment_action_id,
151: ppa.payroll_action_id
152: from pay_payroll_actions ppa,
153: pay_assignment_actions paa
154: where ppa.report_type = 'RL2'
155: and ppa.report_qualifier = 'CAEOYRL2'
156: and ppa.report_category = 'ARCHIVE'

Line 192: from pay_payroll_actions ppa,

188: cursor c_all_asg (l_year_start date,
189: l_year_end date) is
190: select distinct paa.assignment_id,
191: to_number(paa.serial_number)
192: from pay_payroll_actions ppa,
193: pay_assignment_actions paa
194: where ppa.report_type = 'RL2'
195: and ppa.report_qualifier = 'CAEOYRL2'
196: and ppa.report_category = 'ARCHIVE'

Line 229: from pay_payroll_actions ppa,

225: l_year_end date,
226: l_per_id varchar2) is
227: select distinct paa.assignment_id,
228: to_number(paa.serial_number)
229: from pay_payroll_actions ppa,
230: pay_assignment_actions paa
231: where ppa.report_type = 'RL2'
232: and ppa.report_qualifier = 'CAEOYRL2'
233: and ppa.report_category = 'ARCHIVE'

Line 263: from pay_payroll_actions ppa,

259: cursor c_all_asg_in_asgset(l_year_start date,
260: l_year_end date) is
261: select distinct paa.assignment_id,
262: to_number(paa.serial_number)
263: from pay_payroll_actions ppa,
264: pay_assignment_actions paa
265: where ppa.report_type = 'RL2'
266: and ppa.report_qualifier = 'CAEOYRL2'
267: and ppa.report_category = 'ARCHIVE'

Line 314: from pay_payroll_actions

310: into l_effective_date,
311: l_report_type,
312: l_bus_group_id,
313: l_legislative_parameters
314: from pay_payroll_actions
315: where payroll_action_id = pactid;
316:
317: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
318:

Line 583: pay_payroll_actions ppa1

579: hr_locations_all loc,
580: per_all_people_f ppf,
581: per_all_assignments_f paf,
582: pay_assignment_actions paa1,
583: pay_payroll_actions ppa1
584: where ppa1.payroll_action_id = :pactid
585: and paa1.payroll_action_id = ppa1.payroll_action_id
586: and paa1.assignment_id = paf.assignment_id
587: and paf.assignment_type = ''E''

Line 626: token_val pay_payroll_actions.legislative_parameters%type;

622: parameter_list varchar2) return varchar2
623: is
624: start_ptr number;
625: end_ptr number;
626: token_val pay_payroll_actions.legislative_parameters%type;
627: par_value pay_payroll_actions.legislative_parameters%type;
628: begin
629:
630: token_val := name||'=';

Line 627: par_value pay_payroll_actions.legislative_parameters%type;

623: is
624: start_ptr number;
625: end_ptr number;
626: token_val pay_payroll_actions.legislative_parameters%type;
627: par_value pay_payroll_actions.legislative_parameters%type;
628: begin
629:
630: token_val := name||'=';
631: