APPS.PAY_SE_ALECTA dependencies on PAY_BALANCE_DIMENSIONS

Line 227: pay_balance_dimensions PBD,

223: SELECT
224: defined_balance_id
225: FROM
226: pay_defined_balances PDB,
227: pay_balance_dimensions PBD,
228: pay_balance_types PBT
229: WHERE PBT.balance_name = p_balance_type
230: AND PBT.legislation_code = l_legislation_code
231: AND PDB.balance_type_id = PBT.balance_type_id

Line 935: ,pay_balance_dimensions bd

931: CURSOR csr_defined_balance_id
932: IS
933: SELECT db.defined_balance_id
934: FROM pay_defined_balances db
935: ,pay_balance_dimensions bd
936: WHERE db.balance_type_id = p_balance_type_id
937: AND db.balance_dimension_id = bd.balance_dimension_id
938: AND bd.database_item_suffix = p_dimension
939: AND bd.legislation_code = 'SE';

Line 3274: ,pay_balance_dimensions bd

3270: )
3271: IS
3272: SELECT db.defined_balance_id
3273: FROM pay_defined_balances db
3274: ,pay_balance_dimensions bd
3275: WHERE db.balance_type_id = csr_v_balance_type_id
3276: AND db.balance_dimension_id = bd.balance_dimension_id
3277: AND bd.database_item_suffix = csr_v_dimesion
3278: AND bd.legislation_code = 'SE';