APPS.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 245: pay_balance_dimensions pbd

241: select plb.latest_balance_id,
242: 'P' balance_type
243: from pay_person_latest_balances plb,
244: pay_defined_balances pdb,
245: pay_balance_dimensions pbd
246: where pdb.balance_type_id = l_balance_type_id
247: and pdb.defined_balance_id = plb.defined_balance_id
248: and pdb.balance_dimension_id = pbd.balance_dimension_id
249: and pbd.feed_checking_type = 'F'

Line 255: pay_balance_dimensions pbd

251: select plb.latest_balance_id,
252: 'B' balance_type
253: from pay_latest_balances plb,
254: pay_defined_balances pdb,
255: pay_balance_dimensions pbd
256: where pdb.balance_type_id = l_balance_type_id
257: and pdb.defined_balance_id = plb.defined_balance_id
258: and pdb.balance_dimension_id = pbd.balance_dimension_id
259: and pbd.feed_checking_type = 'F';

Line 971: pay_balance_dimensions pbd

967: p_balance_type_id in varchar2) is
968: select alb.latest_balance_id
969: from pay_assignment_latest_balances alb,
970: pay_defined_balances pdb,
971: pay_balance_dimensions pbd
972: where pdb.balance_type_id = p_balance_type_id
973: and pdb.defined_balance_id = alb.defined_balance_id
974: and pdb.balance_dimension_id = pbd.balance_dimension_id
975: and pbd.feed_checking_type = 'F'