DBA Data[Home] [Help]

APPS.PAY_PURGE_PKG dependencies on PAY_BALANCE_SET_MEMBERS

Line 286: pay_balance_set_members pbsm

282: is
283: select
284: distinct pdb.balance_type_id
285: from
286: pay_balance_set_members pbsm
287: ,pay_defined_balances pdb
288: where
289: pbsm.balance_set_id = p_bal_set_id
290: and pdb.defined_balance_id = pbsm.defined_balance_id

Line 1184: from pay_balance_set_members bsm,

1180: pbt.balance_name,
1181: pbt.balance_uom,
1182: pbt.currency_code,
1183: nvl(pbt.jurisdiction_level, 0) jurisdiction_level
1184: from pay_balance_set_members bsm,
1185: pay_defined_balances pdb,
1186: pay_balance_types pbt,
1187: pay_balance_dimensions pbd
1188: where bsm.balance_set_id = p_balance_set_id