412: SELECT pact.payroll_action_id
413: FROM pay_payroll_actions pact
414: WHERE action_type = 'X'
415: AND report_type in ('SQWL', 'SMWL') /* Modified for Bug 14456648 */
416: AND pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
417: ,pact.legislative_parameters) = p_payroll_action_id;
418:
419: CURSOR c_get_report_type IS
420: SELECT report_type
423:
424: CURSOR c_get_child_count(cp_payroll_action_id NUMBER) IS
425: SELECT count (payroll_action_id)
426: FROM pay_payroll_actions p1
427: WHERE pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
428: ,p1.legislative_parameters) IN
429: (
430: SELECT pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
431: ,legislative_parameters)
426: FROM pay_payroll_actions p1
427: WHERE pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
428: ,p1.legislative_parameters) IN
429: (
430: SELECT pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
431: ,legislative_parameters)
432: FROM pay_payroll_actions
433: WHERE payroll_action_id = cp_payroll_action_id
434: );
509:
510: hr_utility.trace('l_report_type '||l_report_type);
511:
512: BEGIN
513: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',legislative_parameters)
514: INTO l_parent_payroll_action_id from pay_payroll_actions
515: WHERE payroll_action_id = p_payroll_action_id;
516: EXCEPTION
517: WHEN NO_DATA_FOUND then
524: IF l_parent_payroll_action_id is not null then
525: BEGIN
526: SELECT count(payroll_action_id) into l_child_count
527: FROM pay_payroll_actions p1
528: WHERE pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',p1.legislative_parameters)
529: = l_parent_payroll_action_id;
530: EXCEPTION
531: WHEN OTHERS THEN
532: null;