DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PAY_DEFINED_BALANCES

Line 894: FROM pay_defined_balances db

890: IS
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

Line 2844: FROM pay_defined_balances db

2840: ,csr_v_dimesion VARCHAR2
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