DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on PAY_DEFINED_BALANCES

Line 971: from pay_defined_balances pdb,

967: cursor c_defined_bal_id ( p_balance_name in varchar2,
968: p_dimension_name in varchar2 )
969: is
970: select pdb.defined_balance_id
971: from pay_defined_balances pdb,
972: pay_balance_types pbt,
973: pay_balance_dimensions pbd
974: where pbt.balance_name = p_balance_name
975: and pbd.dimension_name = p_dimension_name

Line 1156: from pay_defined_balances pdb,

1152: cursor c_defined_bal_id ( p_balance_name in varchar2,
1153: p_dimension_name in varchar2 )
1154: is
1155: select pdb.defined_balance_id
1156: from pay_defined_balances pdb,
1157: pay_balance_types pbt,
1158: pay_balance_dimensions pbd
1159: where pbt.balance_name = p_balance_name
1160: and pbd.dimension_name = p_dimension_name