APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_BALANCE_TYPES

Line 660: pay_balance_types_tl PBT_TL,

656: defined_balance_id
657: FROM
658: pay_defined_balances PDB,
659: pay_balance_dimensions PBD,
660: pay_balance_types_tl PBT_TL,
661: pay_balance_types PBT
662: WHERE PBT_TL.balance_type_id = PBT.balance_type_id
663: and userenv('LANG') = PBT_TL.language
664: AND PBT_TL.balance_name = p_balance_type

Line 661: pay_balance_types PBT

657: FROM
658: pay_defined_balances PDB,
659: pay_balance_dimensions PBD,
660: pay_balance_types_tl PBT_TL,
661: pay_balance_types PBT
662: WHERE PBT_TL.balance_type_id = PBT.balance_type_id
663: and userenv('LANG') = PBT_TL.language
664: AND PBT_TL.balance_name = p_balance_type
665: AND nvl(PBT.legislation_code,l_legislation_code) = l_legislation_code

Line 1910: FROM pay_balance_types pbt,

1906: AND pur.user_row_id = puci.user_row_id;
1907: --
1908: CURSOR c_balance_check(user_balance varchar2) IS
1909: SELECT 1
1910: FROM pay_balance_types pbt,
1911: pay_balance_dimensions pbd,
1912: pay_defined_balances pdb
1913: WHERE pdb.balance_type_id = pbt.balance_type_id
1914: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 1923: FROM pay_balance_types pbt,

1919:
1920: CURSOR csr_user_defined_balance(row_name varchar2) is
1921: SELECT pbt.balance_name,
1922: pbd.database_item_suffix
1923: FROM pay_balance_types pbt,
1924: pay_balance_dimensions pbd,
1925: pay_defined_balances pdb
1926: WHERE pbt.balance_type_id = pdb.balance_type_id
1927: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2085: -- if the balance is not in the pay_balance_types table, then it is a balance for all

2081:
2082: open c_balance_check(l_balance_name);
2083: fetch c_balance_check into l_balance_check;
2084: --
2085: -- if the balance is not in the pay_balance_types table, then it is a balance for all
2086: -- NI categories and its value is determined differently
2087: --
2088: if c_balance_check%NOTFOUND
2089: then