APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_DEFINED_BALANCES

Line 807: from pay_defined_balances

803: --
804: if l_asg_jd_required then
805: select balance_type_id
806: into l_balance_type_id
807: from pay_defined_balances
808: where defined_balance_id = l_defined_balance_id;
809: pay_us_balance_view_pkg.debug_msg(' since jd req, retrieved bal type id of: '
810: || l_balance_type_id);
811: --

Line 1015: ,pay_defined_balances pdb

1011: ,p_business_group_id number) IS
1012: SELECT pdb.defined_balance_id
1013: FROM pay_balance_types pbt
1014: ,pay_balance_dimensions pbd
1015: ,pay_defined_balances pdb
1016: WHERE upper(pbt.balance_name) = p_balance_name
1017: AND ((pbt.business_group_id = p_business_group_id)
1018: OR
1019: (pbt.business_group_id IS NULL AND

Line 1026: ln_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

1022: AND pbd.legislation_code = 'US'
1023: AND pbt.balance_type_id = pdb.balance_type_id
1024: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1025:
1026: ln_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1027:
1028: BEGIN
1029: hr_utility.trace('Entered into us_entry_itd_balance');
1030: hr_utility.trace('p_balance_name := ' || p_balance_name);