DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on PAY_DEFINED_BALANCES

Line 1148: from pay_defined_balances pdb,

1144: cursor c_defined_bal_id ( p_balance_name in varchar2,
1145: p_dimension_name in varchar2 )
1146: is
1147: select pdb.defined_balance_id
1148: from pay_defined_balances pdb,
1149: pay_balance_types pbt,
1150: pay_balance_dimensions pbd
1151: where pbt.balance_name = p_balance_name
1152: and pbd.dimension_name = p_dimension_name

Line 1358: from pay_defined_balances pdb,

1354: cursor c_defined_bal_id ( p_balance_name in varchar2,
1355: p_dimension_name in varchar2 )
1356: is
1357: select pdb.defined_balance_id
1358: from pay_defined_balances pdb,
1359: pay_balance_types pbt,
1360: pay_balance_dimensions pbd
1361: where pbt.balance_name = p_balance_name
1362: and pbd.dimension_name = p_dimension_name