654: CURSOR c_defined_balance IS
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
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
1916: AND nvl(pbt.legislation_code,'GB') = 'GB'
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;
1929: