APPS.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_PERSON_LATEST_BALANCES

Line 172: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)

168: l_batch_size number) is
169: --
170: -- Select all person latest balances to delete.
171: cursor plbc is
172: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
173: USE_NL (PLB) */
174: plb.latest_balance_id
175: from pay_defined_balances pdb,
176: pay_person_latest_balances plb

Line 176: pay_person_latest_balances plb

172: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
173: USE_NL (PLB) */
174: plb.latest_balance_id
175: from pay_defined_balances pdb,
176: pay_person_latest_balances plb
177: where pdb.balance_type_id = l_balance_type_id
178: and plb.defined_balance_id = pdb.defined_balance_id
179: and exists (
180: select null

Line 207: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)

203: --
204:
205: --
206: cursor platbalc is
207: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
208: USE_NL (PLB) */
209: plb.latest_balance_id
210: from pay_defined_balances pdb,
211: pay_person_latest_balances plb

Line 211: pay_person_latest_balances plb

207: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
208: USE_NL (PLB) */
209: plb.latest_balance_id
210: from pay_defined_balances pdb,
211: pay_person_latest_balances plb
212: where pdb.balance_type_id = l_balance_type_id
213: and plb.defined_balance_id = pdb.defined_balance_id;
214: --
215:

Line 243: from pay_person_latest_balances plb,

239:
240: cursor pl_feed_chk is
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

Line 324: delete from pay_person_latest_balances PLB

320: for plbcrec in platbalc loop
321: delete from pay_balance_context_values BCV
322: where BCV.latest_balance_id = plbcrec.latest_balance_id;
323: --
324: delete from pay_person_latest_balances PLB
325: where PLB.latest_balance_id = plbcrec.latest_balance_id;
326: end loop;
327:
328: if g_debug then

Line 389: delete from pay_person_latest_balances PLB

385: if l_rrv_found = 1 then
386: delete from pay_balance_context_values BCV
387: where BCV.latest_balance_id = plbcrec.latest_balance_id;
388: --
389: delete from pay_person_latest_balances PLB
390: where PLB.latest_balance_id = plbcrec.latest_balance_id;
391: end if;
392: end loop;
393: --

Line 458: delete from pay_person_latest_balances PLB

454: for plbcrec in plbc loop
455: delete from pay_balance_context_values BCV
456: where BCV.latest_balance_id = plbcrec.latest_balance_id;
457: --
458: delete from pay_person_latest_balances PLB
459: where PLB.latest_balance_id = plbcrec.latest_balance_id;
460: end loop;
461: --
462: if g_debug then

Line 501: delete from pay_person_latest_balances PLB

497: delete from pay_balance_context_values BCV
498: where BCV.latest_balance_id = plrec.latest_balance_id;
499: --
500: if (plrec.balance_type = 'P') then
501: delete from pay_person_latest_balances PLB
502: where PLB.latest_balance_id = plrec.latest_balance_id;
503: else
504: delete from pay_latest_balances PLB
505: where PLB.latest_balance_id = plrec.latest_balance_id;