APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_BALANCE_TYPES

Line 677: pay_balance_types_tl PBT_TL,

673: defined_balance_id
674: FROM
675: pay_defined_balances PDB,
676: pay_balance_dimensions PBD,
677: pay_balance_types_tl PBT_TL,
678: pay_balance_types PBT
679: WHERE PBT_TL.balance_type_id = PBT.balance_type_id
680: and userenv('LANG') = PBT_TL.language
681: AND PBT_TL.balance_name = p_balance_type

Line 678: pay_balance_types PBT

674: FROM
675: pay_defined_balances PDB,
676: pay_balance_dimensions PBD,
677: pay_balance_types_tl PBT_TL,
678: pay_balance_types PBT
679: WHERE PBT_TL.balance_type_id = PBT.balance_type_id
680: and userenv('LANG') = PBT_TL.language
681: AND PBT_TL.balance_name = p_balance_type
682: AND nvl(PBT.legislation_code,l_legislation_code) = l_legislation_code

Line 1935: FROM pay_balance_types pbt,

1931: AND pur.user_row_id = puci.user_row_id;
1932: --
1933: CURSOR c_balance_check(user_balance varchar2) IS
1934: SELECT 1
1935: FROM pay_balance_types pbt,
1936: pay_balance_dimensions pbd,
1937: pay_defined_balances pdb
1938: WHERE pdb.balance_type_id = pbt.balance_type_id
1939: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 1948: FROM pay_balance_types pbt,

1944:
1945: CURSOR csr_user_defined_balance(row_name varchar2) is
1946: SELECT pbt.balance_name,
1947: pbd.database_item_suffix
1948: FROM pay_balance_types pbt,
1949: pay_balance_dimensions pbd,
1950: pay_defined_balances pdb
1951: WHERE pbt.balance_type_id = pdb.balance_type_id
1952: AND pbd.balance_dimension_id = pdb.balance_dimension_id

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

2106:
2107: open c_balance_check(l_balance_name);
2108: fetch c_balance_check into l_balance_check;
2109: --
2110: -- if the balance is not in the pay_balance_types table, then it is a balance for all
2111: -- NI categories and its value is determined differently
2112: --
2113: if c_balance_check%NOTFOUND
2114: then

Line 2369: FROM pay_balance_types pbt,

2365: AND pur.user_row_id = puci.user_row_id;
2366: --
2367: CURSOR c_balance_check(user_balance varchar2) IS
2368: SELECT 1
2369: FROM pay_balance_types pbt,
2370: pay_balance_dimensions pbd,
2371: pay_defined_balances pdb
2372: WHERE pdb.balance_type_id = pbt.balance_type_id
2373: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 2382: FROM pay_balance_types pbt,

2378:
2379: CURSOR csr_user_defined_balance(row_name varchar2) is
2380: SELECT pbt.balance_name,
2381: pbd.database_item_suffix
2382: FROM pay_balance_types pbt,
2383: pay_balance_dimensions pbd,
2384: pay_defined_balances pdb
2385: WHERE pbt.balance_type_id = pdb.balance_type_id
2386: AND pbd.balance_dimension_id = pdb.balance_dimension_id

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

2540:
2541: open c_balance_check(l_balance_name);
2542: fetch c_balance_check into l_balance_check;
2543: --
2544: -- if the balance is not in the pay_balance_types table, then it is a balance for all
2545: -- NI categories and its value is determined differently
2546: --
2547: if c_balance_check%NOTFOUND
2548: then