APPS.BEN_PRC_BUS dependencies on BEN_PRTT_CLM_GD_OR_SVC_TYP

Line 766: ben_prtt_clm_gd_or_svc_typ pcg

762: l_api_updating boolean;
763:
764: cursor c_pcg is
765: select 'x' from
766: ben_prtt_clm_gd_or_svc_typ pcg
767: where prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id ;
768: --
769: l_ctfn_pending_flag varchar2(1) ;
770: l_dummy_var varchar2(1) ;

Line 1795: ben_prtt_clm_gd_or_svc_typ pcg,

1791: decode(pgs.GD_SVC_RECD_BASIS_CD, 'MOPLYRND', add_months(yrp.end_date,pgs.GD_SVC_RECD_BASIS_MO),yrp.end_date))) earliest_submit_date
1792: from ben_prtt_enrt_rslt_f pen,
1793: ben_popl_yr_perd cpy,
1794: ben_yr_perd yrp,
1795: ben_prtt_clm_gd_or_svc_typ pcg,
1796: ben_pl_gd_or_svc_f pgs,
1797: ben_gd_or_svc_typ gds
1798: where pcg.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
1799: and pcg.pl_gd_or_svc_id = pgs.pl_gd_or_svc_id