268: l_business_group_id number;
269: --
270: BEGIN
271: --
272: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters),
273: pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
274: INTO l_report_mode, l_business_group_id
275: FROM pay_payroll_actions ppa
276: WHERE ppa.payroll_action_id = pactid;
269: --
270: BEGIN
271: --
272: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters),
273: pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
274: INTO l_report_mode, l_business_group_id
275: FROM pay_payroll_actions ppa
276: WHERE ppa.payroll_action_id = pactid;
277: --
283: FROM PER_ALL_PEOPLE_F PPF
284: ,pay_payroll_actions ppa
285: WHERE ppa.payroll_action_id = :payroll_action_id
286: AND PPF.BUSINESS_GROUP_ID
287: = NVL(pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'', ppa.legislative_parameters), PPF.BUSINESS_GROUP_ID)
288: ORDER BY PPF.PERSON_ID';
289: --
290: ELSIF (l_report_mode = 'FAILED') THEN
291: --
296: ,pay_payroll_actions ppa
297: WHERE ppa.payroll_action_id = :payroll_action_id
298: AND PPF.ERROR_DESCRIPTION <> ''SUCCESS''
299: AND PPF.BUSINESS_GROUP_ID
300: = NVL(pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'', ppa.legislative_parameters), PPF.BUSINESS_GROUP_ID)
301: ORDER BY PPF.PERSON_ID';
302: --
303: END IF;
304: --
376: l_report_mode varchar2(100);
377:
378: BEGIN
379: --
380: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters),
381: pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
382: INTO l_report_mode,l_business_group_id
383: FROM pay_payroll_actions ppa
384: WHERE ppa.payroll_action_id = pactid;
377:
378: BEGIN
379: --
380: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters),
381: pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
382: INTO l_report_mode,l_business_group_id
383: FROM pay_payroll_actions ppa
384: WHERE ppa.payroll_action_id = pactid;
385: --
1718: BEGIN
1719: --
1720: -- Get the report mode into local variable.
1721: --
1722: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters)
1723: INTO l_report_mode
1724: FROM pay_payroll_actions ppa
1725: ,pay_assignment_actions paa
1726: WHERE ppa.payroll_action_id = paa.payroll_action_id
2290: -- record with error_description as SUCCESS. This error_description is used in
2291: -- procedure submit_migration to decide whetehr this request is re-run or a fresh
2292: -- request.
2293: --
2294: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
2295: INTO l_business_group_id
2296: FROM pay_payroll_actions ppa
2297: WHERE ppa.payroll_action_id = pactid;
2298: --