APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 676: pay_balance_dimensions PBD,

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
680: and userenv('LANG') = PBT_TL.language

Line 1936: pay_balance_dimensions pbd,

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
1940: AND pbt.balance_name = user_balance

Line 1949: pay_balance_dimensions pbd,

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

Line 2370: pay_balance_dimensions pbd,

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
2374: AND pbt.balance_name = user_balance

Line 2383: pay_balance_dimensions pbd,

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

Line 3073: from pay_balance_dimensions pbd

3069: select decode(legislation_code,
3070: 'GB',replace(database_item_suffix,database_item_suffix,
3071: ' ' || substr(database_item_suffix,2)),
3072: database_item_suffix || ' USER-REG')
3073: from pay_balance_dimensions pbd
3074: where dimension_name = p_dimension_name;
3075:
3076: l_user_table_id number;
3077: l_user_row_id number;

Line 3151: pay_balance_dimensions pbd

3147:
3148: cursor c_check_row_exists(l_user_table_id number) is
3149: select 1
3150: from pay_user_rows_f pur,
3151: pay_balance_dimensions pbd
3152: where pur.row_low_range_or_name =
3153: p_balance_name ||
3154: replace(pbd.database_item_suffix,pbd.database_item_suffix,
3155: ' '|| substr(pbd.database_item_suffix,2))