APPS.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_LATEST_BALANCES

Line 192: pay_latest_balances lb

188: cursor lbc is
189: select
190: lb.latest_balance_id
191: from pay_defined_balances pdb,
192: pay_latest_balances lb
193: where pdb.balance_type_id = l_balance_type_id
194: and lb.defined_balance_id = pdb.defined_balance_id
195: and exists (
196: select null

Line 219: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)

215:
216: --
217: -- Select all latest balances to delete.
218: cursor latbalc is
219: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)
220: USE_NL (PLB) */
221: plb.latest_balance_id
222: from pay_defined_balances pdb,
223: pay_latest_balances plb

Line 223: pay_latest_balances plb

219: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)
220: USE_NL (PLB) */
221: plb.latest_balance_id
222: from pay_defined_balances pdb,
223: pay_latest_balances plb
224: where pdb.balance_type_id = l_balance_type_id
225: and plb.defined_balance_id = pdb.defined_balance_id;
226: --
227: -- Select if run result value exists for input value

Line 253: from pay_latest_balances plb,

249: and pbd.feed_checking_type = 'F'
250: union
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

Line 354: delete from pay_latest_balances LB

350: --
351: -- Delete all latest Balanaces.
352: for lbcrec in latbalc loop
353: --
354: delete from pay_latest_balances LB
355: where LB.latest_balance_id = lbcrec.latest_balance_id;
356: end loop;
357: --
358: end if;

Line 440: delete from pay_latest_balances ALB

436: end if;
437: close ivchk;
438: end if;
439: if l_rrv_found = 1 then
440: delete from pay_latest_balances ALB
441: where ALB.latest_balance_id = lbcrec.latest_balance_id;
442: end if;
443: end loop;
444:

Line 481: delete from pay_latest_balances ALB

477: hr_utility.set_location(lv_proc_name,70);
478: end if;
479: --
480: for lbcrec in lbc loop
481: delete from pay_latest_balances ALB
482: where ALB.latest_balance_id = lbcrec.latest_balance_id;
483: end loop;
484: --
485: end if;

Line 504: delete from pay_latest_balances PLB

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;
506: end if;
507: --
508: end loop;