DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PAY_BALANCE_DIMENSIONS

Line 895: ,pay_balance_dimensions bd

891: CURSOR csr_defined_balance_id
892: IS
893: SELECT db.defined_balance_id
894: FROM pay_defined_balances db
895: ,pay_balance_dimensions bd
896: WHERE db.balance_type_id = p_balance_type_id
897: AND db.balance_dimension_id = bd.balance_dimension_id
898: AND bd.database_item_suffix = p_dimension
899: AND bd.legislation_code = 'SE';

Line 2845: ,pay_balance_dimensions bd

2841: )
2842: IS
2843: SELECT db.defined_balance_id
2844: FROM pay_defined_balances db
2845: ,pay_balance_dimensions bd
2846: WHERE db.balance_type_id = csr_v_balance_type_id
2847: AND db.balance_dimension_id = bd.balance_dimension_id
2848: AND bd.database_item_suffix = csr_v_dimesion
2849: AND bd.legislation_code = 'SE';