APPS.BEN_PRTT_CLM_GD_R_SVC_TYP_API dependencies on BEN_PRTT_CLM_GD_OR_SVC_TYP

Line 33: ben_prtt_clm_gd_or_svc_typ pcg

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
37: pct.effective_start_date and

Line 90: ben_prtt_clm_gd_or_svc_typ pcg

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
94: and p_effective_date between

Line 278: l_prtt_clm_gd_or_svc_typ_id ben_prtt_clm_gd_or_svc_typ.prtt_clm_gd_or_svc_typ_id%TYPE;

274: ) is
275: --
276: -- Declare cursors and local variables
277: --
278: l_prtt_clm_gd_or_svc_typ_id ben_prtt_clm_gd_or_svc_typ.prtt_clm_gd_or_svc_typ_id%TYPE;
279: l_proc varchar2(72) := g_package||'create_PRTT_CLM_GD_R_SVC_TYP';
280: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;
281: --#### Tilak ####
282: l_ctfn_rqd_flag varchar2(30) ;

Line 280: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;

276: -- Declare cursors and local variables
277: --
278: l_prtt_clm_gd_or_svc_typ_id ben_prtt_clm_gd_or_svc_typ.prtt_clm_gd_or_svc_typ_id%TYPE;
279: l_proc varchar2(72) := g_package||'create_PRTT_CLM_GD_R_SVC_TYP';
280: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;
281: --#### Tilak ####
282: l_ctfn_rqd_flag varchar2(30) ;
283:
284: cursor c_pct_gdsvc is

Line 573: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;

569: --
570: -- Declare cursors and local variables
571: --
572: l_proc varchar2(72) := g_package||'update_PRTT_CLM_GD_R_SVC_TYP';
573: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;
574:
575: --#### Tilak ####
576: l_ctfn_rqd_flag varchar2(30) ;
577:

Line 832: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;

828: --
829: -- Declare cursors and local variables
830: --
831: l_proc varchar2(72) := g_package||'update_PRTT_CLM_GD_R_SVC_TYP';
832: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;
833: --
834: begin
835: --
836: hr_utility.set_location('Entering:'|| l_proc, 10);