APPS.PAY_CA_RL1_REG dependencies on PAY_PAYROLL_ACTIONS

Line 53: pay_payroll_actions table instead of

49: query with high cost in 11.5.8.
50:
51: 16-AUG-2002 vpandya 115.11 Changed c_all_pres for perfoemance 11.5.8,
52: getting Quebec Busi.number from
53: pay_payroll_actions table instead of
54: archiver table.
55: Changed c_all_asg_in_asgset for 11.5.8 perf.
56: added table hr_all_organization_units table
57: to avoid cartesian join.

Line 159: leg_param pay_payroll_actions.legislative_parameters%type;

155: end;
156:
157: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
158: l_payroll_id number;
159: leg_param pay_payroll_actions.legislative_parameters%type;
160:
161: begin
162: --hr_utility.trace_on('Y','RL1');
163: hr_utility.trace('begining of range_cursor 1 ');

Line 166: from pay_payroll_actions ppa

162: --hr_utility.trace_on('Y','RL1');
163: hr_utility.trace('begining of range_cursor 1 ');
164: select legislative_parameters
165: into leg_param
166: from pay_payroll_actions ppa
167: where ppa.payroll_action_id = pactid;
168:
169:
170: /* pay reg code */

Line 179: pay_payroll_actions ppa,

175: ff_database_items fdi1,
176: ff_database_items fdi2,
177: ff_archive_items fai3,
178: ff_database_items fdi3,
179: pay_payroll_actions ppa,
180: pay_assignment_actions paa
181: where ppa.payroll_action_id = :payroll_action_id
182: and fai1.user_entity_id = fdi1.user_entity_id
183: and fdi1.user_name = ''CAEOY_TAXATION_YEAR''

Line 239: legislative parameter of pay_payroll_actions for RL1 archiver

235: ln_arch_pact_id number;
236: lv_per_id varchar2(30);
237:
238: /* For performance: getting all pre organization ids from
239: legislative parameter of pay_payroll_actions for RL1 archiver
240: for the given year within same business group.
241: */
242: cursor c_all_pres is
243: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 245: from pay_payroll_actions ppa

241: */
242: cursor c_all_pres is
243: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
244: ppa.legislative_parameters )
245: from pay_payroll_actions ppa
246: where ppa.report_type = 'RL1'
247: and ppa.report_qualifier = 'CAEOYRL1'
248: and ppa.report_category = 'CAEOYRL1'
249: and ppa.effective_date = l_year_end

Line 259: from pay_payroll_actions ppa,

255: cp_assignment_id in number,
256: cp_pre_org_id in varchar2) is
257: select paa.assignment_action_id,
258: ppa.payroll_action_id
259: from pay_payroll_actions ppa,
260: pay_assignment_actions paa
261: where ppa.report_type = 'RL1'
262: and ppa.report_qualifier = 'CAEOYRL1'
263: and ppa.report_category = 'CAEOYRL1'

Line 366: from pay_payroll_actions

362: into l_effective_date,
363: l_report_type,
364: l_bus_group_id,
365: l_legislative_parameters
366: from pay_payroll_actions
367: where payroll_action_id = pactid;
368:
369: hr_utility.trace('begining of action creation 2 '||
370: to_char(l_bus_group_id));

Line 657: pay_payroll_actions ppa1

653: hr_locations_all loc,
654: per_all_people_f ppf,
655: per_all_assignments_f paf,
656: pay_assignment_actions paa1,
657: pay_payroll_actions ppa1
658: where ppa1.payroll_action_id = :pactid
659: and paa1.payroll_action_id = ppa1.payroll_action_id
660: and paa1.assignment_id = paf.assignment_id
661: and paf.business_group_id = ppa1.business_group_id

Line 704: token_val pay_payroll_actions.legislative_parameters%type;

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

Line 705: par_value pay_payroll_actions.legislative_parameters%type;

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