DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PAY_DEFINED_BALANCES

Line 226: pay_defined_balances PDB,

222: CURSOR c_defined_balance IS
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

Line 934: FROM pay_defined_balances db

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

Line 3273: FROM pay_defined_balances db

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