DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_US_PAYROLL_UTILS

Line 1401: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)

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

Line 1554: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)

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:

Line 3800: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',legislative_parameters)

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);

Line 3814: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)

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: