APPS.PQH_GSP_POST_PROCESS dependencies on BEN_OIPL_F

Line 775: Ben_Oipl_F Oipl

771: Cursor Ben_Dtls(P_Pl_id In Number,
772: P_Point_id In Number) Is
773: Select Oipl.Oipl_Id, Opt.Opt_Id
774: From Ben_Opt_F Opt,
775: Ben_Oipl_F Oipl
776: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
777: and Opt.mapping_table_Pk_Id = P_Point_id
778: and P_Effective_Date
779: Between Opt.Effective_Start_Date

Line 928: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

924: l_VOIDD_DT Date;
925: l_Step_Exists Varchar2(1) := 'N';
926: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
927: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
928: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
929: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
930: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
931: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
932: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 955: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

951: l_start_date ben_yr_perd.start_date%TYPE;
952: l_end_date ben_yr_perd.end_date%TYPE;
953: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
954: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
955: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
956: l_New_Enrlmt_Dt Date;
957: l_max_lf_evt_date Date;
958:
959: Begin

Line 2284: From Ben_Oipl_F Oipl,

2280: Between Asgt.Effective_start_Date and Asgt.Effective_end_Date;
2281:
2282: Cursor Step_Dtls(P_Oipl_Id IN NUmber) Is
2283: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
2284: From Ben_Oipl_F Oipl,
2285: Ben_pl_F Pl,
2286: Ben_Opt_F Opt,
2287: Per_Spinal_points point,
2288: Per_Grade_Spines_f GSpine,

Line 2319: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

2315: and Effective_End_Date;
2316:
2317: L_PL_Id Ben_Pl_F.Pl_Id%TYPE;
2318: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
2319: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
2320: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
2321: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2322: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2323: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;

Line 2982: Ben_Oipl_F Oipl

2978: Cursor Ben_Dtls(P_Pl_id In Number,
2979: P_Point_id In Number) Is
2980: Select Oipl.Oipl_Id, Opt.Opt_Id
2981: From Ben_Opt_F Opt,
2982: Ben_Oipl_F Oipl
2983: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
2984: and Opt.mapping_table_Pk_Id = P_Point_id
2985: and P_Effective_Date
2986: Between Opt.Effective_Start_Date

Line 3069: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

3065: l_VOIDD_DT Date;
3066: l_Step_Exists Varchar2(1) := 'N';
3067: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
3068: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
3069: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3070: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3071: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3072: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3073: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 3096: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

3092: l_start_date ben_yr_perd.start_date%TYPE;
3093: l_end_date ben_yr_perd.end_date%TYPE;
3094: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3095: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3096: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3097:
3098:
3099: Begin
3100: