APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_PREM_CSTG_BY_SGMT_F
Line 194: from ben_prem_cstg_by_sgmt_f cbs
190: */
191:
192: cursor csr_cbs is
193: select cbs.sgmt_num, cbs.sgmt_cstg_mthd_cd, cbs.sgmt_cstg_mthd_rl 194: from ben_prem_cstg_by_sgmt_f cbs 195: where cbs.actl_prem_id = p_actl_prem_id
196: and cbs.business_group_id+0 = p_business_group_id
197: and p_effective_date between
198: cbs.effective_start_date and cbs.effective_end_date