APPS.PQH_GSP_POST_PROCESS dependencies on BEN_OIPL_F

Line 816: Ben_Oipl_F Oipl

812: Cursor Ben_Dtls(P_Pl_id In Number,
813: P_Point_id In Number) Is
814: Select Oipl.Oipl_Id, Opt.Opt_Id
815: From Ben_Opt_F Opt,
816: Ben_Oipl_F Oipl
817: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
818: and Opt.mapping_table_Pk_Id = P_Point_id
819: and P_Effective_Date
820: Between Opt.Effective_Start_Date

Line 1029: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

1025: l_VOIDD_DT Date;
1026: l_Step_Exists Varchar2(1) := 'N';
1027: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
1028: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
1029: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
1030: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1031: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1032: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
1033: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 1056: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

1052: l_start_date ben_yr_perd.start_date%TYPE;
1053: l_end_date ben_yr_perd.end_date%TYPE;
1054: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1055: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
1056: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
1057: l_New_Enrlmt_Dt Date;
1058: l_max_lf_evt_date Date;
1059:
1060: Begin

Line 2444: From Ben_Oipl_F Oipl,

2440: Between Asgt.Effective_start_Date and Asgt.Effective_end_Date;
2441:
2442: Cursor Step_Dtls(P_Oipl_Id IN NUmber) Is
2443: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
2444: From Ben_Oipl_F Oipl,
2445: Ben_pl_F Pl,
2446: Ben_Opt_F Opt,
2447: Per_Spinal_points point,
2448: Per_Grade_Spines_f GSpine,

Line 2479: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

2475: and Effective_End_Date;
2476:
2477: L_PL_Id Ben_Pl_F.Pl_Id%TYPE;
2478: L_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
2479: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
2480: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
2481: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2482: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2483: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;

Line 3142: Ben_Oipl_F Oipl

3138: Cursor Ben_Dtls(P_Pl_id In Number,
3139: P_Point_id In Number) Is
3140: Select Oipl.Oipl_Id, Opt.Opt_Id
3141: From Ben_Opt_F Opt,
3142: Ben_Oipl_F Oipl
3143: Where Opt.Mapping_table_name = 'PER_SPINAL_POINTS'
3144: and Opt.mapping_table_Pk_Id = P_Point_id
3145: and P_Effective_Date
3146: Between Opt.Effective_Start_Date

Line 3229: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

3225: l_VOIDD_DT Date;
3226: l_Step_Exists Varchar2(1) := 'N';
3227: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;
3228: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;
3229: L_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3230: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3231: L_Oipl_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
3232: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_Id%TYPE;
3233: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

Line 3256: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

3252: l_start_date ben_yr_perd.start_date%TYPE;
3253: l_end_date ben_yr_perd.end_date%TYPE;
3254: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3255: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3256: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3257:
3258:
3259: Begin
3260: