APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 659: pay_balance_dimensions PBD,

655: SELECT
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

Line 1911: pay_balance_dimensions pbd,

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

Line 1924: pay_balance_dimensions pbd,

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

Line 2672: from pay_balance_dimensions pbd

2668: select decode(legislation_code,
2669: 'GB',replace(database_item_suffix,database_item_suffix,
2670: ' ' || substr(database_item_suffix,2)),
2671: database_item_suffix || ' USER-REG')
2672: from pay_balance_dimensions pbd
2673: where dimension_name = p_dimension_name;
2674:
2675: l_user_table_id number;
2676: l_user_row_id number;

Line 2750: pay_balance_dimensions pbd

2746:
2747: cursor c_check_row_exists(l_user_table_id number) is
2748: select 1
2749: from pay_user_rows_f pur,
2750: pay_balance_dimensions pbd
2751: where pur.row_low_range_or_name =
2752: p_balance_name ||
2753: replace(pbd.database_item_suffix,pbd.database_item_suffix,
2754: ' '|| substr(pbd.database_item_suffix,2))