DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 973: pay_balance_dimensions pbd

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
976: and pbt.balance_type_id = pdb.balance_type_id
977: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 1158: pay_balance_dimensions pbd

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
1161: and pbt.balance_type_id = pdb.balance_type_id
1162: and pdb.balance_dimension_id = pbd.balance_dimension_id