APPS.BEN_BATCH_REPORTING dependencies on BEN_PERSON_ACTIONS

Line 407: ben_person_actions bpa

403: select count(*) amount,ler.typ_cd
404: from ben_batch_ler_info bli,
405: ben_benefit_actions bft,
406: ben_ler_f ler,
407: ben_person_actions bpa
408: where bft.benefit_action_id = bli.benefit_action_id
409: and bft.benefit_action_id = l_c0.benefit_action_id
410: and bpa.benefit_action_id = bft.benefit_action_id
411: and ler.ler_id = bli.ler_id

Line 432: from BEN_PERSON_ACTIONS BPA

428: AND BFT.PROCESS_DATE BETWEEN LER.EFFECTIVE_START_DATE AND LER.EFFECTIVE_END_DATE
429: AND BLI.TMPRL_FLAG = 'Y'
430: and BLI.PERSON_ID in
431: (select BPA.PERSON_ID
432: from BEN_PERSON_ACTIONS BPA
433: where BPA.ACTION_STATUS_CD in ('P','U')
434: AND BPA.BENEFIT_ACTION_ID = l_c0.benefit_action_id
435: )
436: GROUP BY LER.TYP_CD;

Line 441: from ben_person_actions pac,

437:
438: --
439: cursor c2 is
440: select count(*)
441: from ben_person_actions pac,
442: ben_benefit_actions bft
443: where bft.benefit_action_id = pac.benefit_action_id
444: /* and bft.request_id = p_concurrent_request_id */
445: and bft.benefit_action_id = l_c0.benefit_action_id

Line 455: from ben_person_actions pac,

451: and bli.tmprl_flag = 'Y');
452: --
453: cursor c3 is
454: select count(*)
455: from ben_person_actions pac,
456: ben_benefit_actions bft
457: where bft.benefit_action_id = pac.benefit_action_id
458: /* and bft.request_id = p_concurrent_request_id */
459: and bft.benefit_action_id = l_c0.benefit_action_id

Line 690: ben_person_actions bpa

686: bli.benefit_action_id,
687: bli.person_id
688: from ben_batch_ler_info bli,
689: ben_benefit_actions bft,
690: ben_person_actions bpa
691: where bft.benefit_action_id = bli.benefit_action_id
692: and bli.tmprl_flag = 'N'
693: and bft.benefit_action_id = l_c0.benefit_action_id
694: and bpa.benefit_action_id = bft.benefit_action_id

Line 881: ben_person_actions bpa

877: bli.person_id
878: from ben_batch_ler_info bli,
879: ben_benefit_actions bft,
880: /* Bug 2243050: Check whether the person has errored out nocopy */
881: ben_person_actions bpa
882: /* Bug 2243050: Check whether the person has errored out nocopy */
883: where bft.benefit_action_id = bli.benefit_action_id
884: and bli.tmprl_flag = 'N'
885: and bft.request_id = p_concurrent_request_id