APPS.PAY_PURGE_PKG dependencies on PAY_DEFINED_BALANCES

Line 287: ,pay_defined_balances pdb

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
291: order by pdb.balance_type_id

Line 925: pay_defined_balances pdb

921: is
922: select
923: pbd.period_type
924: from
925: pay_defined_balances pdb
926: ,pay_balance_dimensions pbd
927: where
928: pdb.defined_balance_id = p_defined_balance_id
929: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1125: pay_defined_balances pdb

1121: pbd.database_item_suffix
1122: into l_balance_name
1123: from pay_balance_types pbt,
1124: pay_balance_dimensions pbd,
1125: pay_defined_balances pdb
1126: where pdb.defined_balance_id = c1rec.defined_balance_id
1127: and pbt.balance_type_id = pdb.balance_type_id
1128: and pbd.balance_dimension_id = pdb.balance_dimension_id;
1129:

Line 1185: pay_defined_balances pdb,

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
1189: and pdb.defined_balance_id = bsm.defined_balance_id

Line 1204: pay_defined_balances pdb,

1200: from ff_fdi_usages_f fdu,
1201: ff_formulas_f fff,
1202: ff_database_items fdi,
1203: ff_user_entities fue,
1204: pay_defined_balances pdb,
1205: pay_balance_types pbt,
1206: pay_balance_dimensions pbd
1207: where ((fff.business_group_id is null and fff.legislation_code is null)
1208: or (fff.business_group_id is null