APPS.BEN_PRTT_CLM_GD_R_SVC_TYP_API dependencies on BEN_PL_GD_R_SVC_CTFN_F

Line 24: ben_pl_gd_r_svc_ctfn_f

20: l_proc varchar2(72) := g_package||'check_remb_rqst_ctfn_rqs';
21:
22: cursor c_pct_gdsvc is
23: select 'x' from
24: ben_pl_gd_r_svc_ctfn_f
25: where pl_gd_or_svc_id = p_pl_gd_or_svc_id
26: and p_effective_date between
27: effective_start_date and
28: effective_end_date ;

Line 32: ben_pl_gd_r_svc_ctfn_f pct,

28: effective_end_date ;
29:
30: cursor c_pct_remb is
31: select 'x' from
32: ben_pl_gd_r_svc_ctfn_f pct,
33: ben_prtt_clm_gd_or_svc_typ pcg
34: where pcg.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
35: and pct.pl_gd_or_svc_id = pcg.pl_gd_or_svc_id
36: and p_effective_date between

Line 286: ben_pl_gd_r_svc_ctfn_f

282: l_ctfn_rqd_flag varchar2(30) ;
283:
284: cursor c_pct_gdsvc is
285: select * from
286: ben_pl_gd_r_svc_ctfn_f
287: where pl_gd_or_svc_id = p_pl_gd_or_svc_id
288: and p_effective_date between
289: effective_start_date and
290: effective_end_date ;

Line 580: ben_pl_gd_r_svc_ctfn_f

576: l_ctfn_rqd_flag varchar2(30) ;
577:
578: cursor c_pct_gdsvc is
579: select * from
580: ben_pl_gd_r_svc_ctfn_f
581: where pl_gd_or_svc_id = p_pl_gd_or_svc_id
582: and p_effective_date between
583: effective_start_date and
584: effective_end_date ;