eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_PREM_CSTG_BY_SGMT_F

Line 188: from ben_prem_cstg_by_sgmt_f cbs

184: */
185:
186: cursor csr_cbs is
187: select cbs.sgmt_num, cbs.sgmt_cstg_mthd_cd, cbs.sgmt_cstg_mthd_rl
188: from ben_prem_cstg_by_sgmt_f cbs
189: where cbs.actl_prem_id = p_actl_prem_id
190: and cbs.business_group_id+0 = p_business_group_id
191: and p_effective_date between
192: cbs.effective_start_date and cbs.effective_end_date