85: select ppa.legislative_parameters
86: into lv_legislative_param
87: from pay_payroll_actions ppa
88: where payroll_action_id = pactid;
89: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
90: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
91:
92: if (l_gre_id is not null) then
93: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);
86: into lv_legislative_param
87: from pay_payroll_actions ppa
88: where payroll_action_id = pactid;
89: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
90: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
91:
92: if (l_gre_id is not null) then
93: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);
94: elsif (l_pre_organization_id is not null) then
128: l_proc := gv_package_name||'action_creation';
129: hr_utility.set_location(l_proc, 10);
130: hr_utility.trace('PACTID = '||to_char(pactid));
131: SELECT effective_date,
132: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
133: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),
134: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
135: INTO ld_effective_date,
136: ln_tax_unit_id,
129: hr_utility.set_location(l_proc, 10);
130: hr_utility.trace('PACTID = '||to_char(pactid));
131: SELECT effective_date,
132: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
133: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),
134: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
135: INTO ld_effective_date,
136: ln_tax_unit_id,
137: l_pre_organization_id,
130: hr_utility.trace('PACTID = '||to_char(pactid));
131: SELECT effective_date,
132: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
133: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),
134: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
135: INTO ld_effective_date,
136: ln_tax_unit_id,
137: l_pre_organization_id,
138: l_report_type
219: select ppa.legislative_parameters
220: into lv_legislative_param
221: from pay_payroll_actions ppa
222: where payroll_action_id = pactid;
223: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
224: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
225:
226: -- fix for bug 7518875 starts here.
227:
220: into lv_legislative_param
221: from pay_payroll_actions ppa
222: where payroll_action_id = pactid;
223: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
224: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
225:
226: -- fix for bug 7518875 starts here.
227:
228: SELECT effective_date,
225:
226: -- fix for bug 7518875 starts here.
227:
228: SELECT effective_date,
229: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
230: INTO ld_effective_date,
231: l_report_type
232: FROM pay_payroll_actions
233: WHERE payroll_action_id = pactid;