APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_DEFINED_BALANCES

Line 675: pay_defined_balances PDB,

671: CURSOR c_defined_balance IS
672: SELECT
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

Line 1937: pay_defined_balances pdb

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
1940: AND pbt.balance_name = user_balance
1941: AND nvl(pbt.legislation_code,'GB') = 'GB'

Line 1950: pay_defined_balances pdb

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
1953: AND row_name = pbt.balance_name || pbd.database_item_suffix;
1954:

Line 2371: pay_defined_balances pdb

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
2374: AND pbt.balance_name = user_balance
2375: AND nvl(pbt.legislation_code,'GB') = 'GB'

Line 2384: pay_defined_balances pdb

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
2387: AND row_name = pbt.balance_name || pbd.database_item_suffix;
2388: