1397: -- Check the balance.
1398: --
1399:
1400: BEGIN
1401: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
1402: INTO l_transfer_gre_id
1403: FROM pay_payroll_actions
1404: WHERE payroll_action_id = pactid;
1405: EXCEPTION
1550: into lockingactid
1551: from dual;
1552: --
1553:
1554: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
1555: INTO l_transfer_gre_id
1556: FROM pay_payroll_actions
1557: WHERE payroll_action_id = pactid;
1558:
3796: of old sqwl process "State Quarterly Wage Listing", customer need use
3797: new enhanced SQWL Process.
3798: */
3799:
3800: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',legislative_parameters)
3801: INTO l_parent_payroll_action_id
3802: FROM pay_payroll_actions
3803: WHERE payroll_action_id = pactid;
3804: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);
3810: hr_utility.set_message(801, 'PAY_75270_SQWL_NO_PARENT_EXIST');
3811: hr_utility.raise_error;
3812: END IF;
3813:
3814: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
3815: INTO l_gre
3816: FROM pay_payroll_actions
3817: WHERE payroll_action_id = pactid;
3818: