APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_PRTT_PREM_F

Line 383: from ben_prtt_prem_by_mo_f prm, ben_prtt_prem_f ppe

379:
380: cursor c_premium (p_prtt_enrt_rslt_id number,
381: p_effective_start_date date, p_effective_date date) is
382: select distinct 'Y'
383: from ben_prtt_prem_by_mo_f prm, ben_prtt_prem_f ppe
384: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
385: and ppe.prtt_prem_id = prm.prtt_prem_id
386: -- any premiums between esd of result and date we are voided it
387: and to_date(to_char(prm.mo_num)||'-'||to_char(prm.yr_num), 'mm-yyyy')

Line 1023: ben_prtt_prem_f ppe

1019: apr.cr_lkbk_val,apr.cr_lkbk_crnt_py_only_flag,
1020: ppe.effective_start_date
1021: from ben_actl_prem_f apr,
1022: ben_per_in_ler pil,
1023: ben_prtt_prem_f ppe
1024: where apr.prem_asnmt_cd = 'ENRT' -- PROC are dealt with in benprplo.pkb
1025: and apr.business_group_id+0 = p_business_group_id
1026: and ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1027: and p_effective_date between