APPS.BEN_PRTT_CLM_GD_R_SVC_TYP_API dependencies on BEN_PRTT_RMT_RQST_CTFN_PRVDD_F

Line 80: ben_prtt_rmt_rqst_ctfn_prvdd_f

76: l_proc varchar2(72) := g_package||'check_remb_rqst_ctfn_prvdd';
77:
78: cursor c_pqc_gdsvc is
79: select 'x' from
80: ben_prtt_rmt_rqst_ctfn_prvdd_f
81: where prtt_clm_gd_or_svc_typ_id = p_prtt_clm_gd_or_svc_typ_id
82: and reimbmt_ctfn_recd_dt is null
83: and p_effective_date between
84: effective_start_date and

Line 89: ben_prtt_rmt_rqst_ctfn_prvdd_f pqc,

85: effective_end_date ;
86:
87: cursor c_pqc_prc is
88: select 'x' from
89: ben_prtt_rmt_rqst_ctfn_prvdd_f pqc,
90: ben_prtt_clm_gd_or_svc_typ pcg
91: where pcg.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
92: and pqc.prtt_clm_gd_or_svc_typ_id = pcg.prtt_clm_gd_or_svc_typ_id
93: and pqc.reimbmt_ctfn_recd_dt is null

Line 163: from ben_prtt_rmt_rqst_ctfn_prvdd_f

159:
160: --cursor to check the certifcate already exist
161: cursor c_pqc is
162: select 'x'
163: from ben_prtt_rmt_rqst_ctfn_prvdd_f
164: where prtt_clm_gd_or_svc_typ_id = p_prtt_clm_gd_or_svc_typ_id
165: and p_pl_gd_r_svc_ctfn_id = p_pl_gd_r_svc_ctfn_id
166: and nvl(reimbmt_ctfn_typ_cd,-1) = nvl(p_reimbmt_ctfn_typ_cd ,-1)
167: and p_effective_date between effective_start_date