DBA Data[Home] [Help]

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