APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_PRTT_PREM_F

Line 377: from ben_prtt_prem_by_mo_f prm, ben_prtt_prem_f ppe

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

Line 1010: ben_prtt_prem_f ppe

1006: apr.cr_lkbk_val,apr.cr_lkbk_crnt_py_only_flag,
1007: ppe.effective_start_date
1008: from ben_actl_prem_f apr,
1009: ben_per_in_ler pil,
1010: ben_prtt_prem_f ppe
1011: where apr.prem_asnmt_cd = 'ENRT' -- PROC are dealt with in benprplo.pkb
1012: and apr.business_group_id+0 = p_business_group_id
1013: and ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1014: and p_effective_date between