APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PL_TYP_F

Line 830: From Ben_Pl_Typ_F

826: and Oipl.Effective_End_Date;
827:
828: Cursor PlanType is
829: Select Pl_typ_Id
830: From Ben_Pl_Typ_F
831: Where Opt_typ_Cd = 'GSP'
832: and P_Effective_Date
833: Between Effective_Start_Date
834: and Effective_End_Date;

Line 1032: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_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;
1034: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1035: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
1036: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 2952: from ben_pl_f pl,ben_pl_typ_f pltyp

2948: and p_effective_date between effective_start_date and effective_end_date;
2949: --
2950: Cursor csr_grade_pl(p_grade_id in number) is
2951: select pl_id
2952: from ben_pl_f pl,ben_pl_typ_f pltyp
2953: where pltyp.business_group_id = p_business_group_id
2954: and pltyp.opt_typ_cd = 'GSP'
2955: and p_effective_date between pltyp.effective_start_date and pltyp.effective_end_date
2956: and pl.pl_typ_id = pltyp.pl_typ_id

Line 3156: From Ben_Pl_Typ_F

3152: and Oipl.Effective_End_Date;
3153:
3154: Cursor PlanType(p_business_group_id in number) is
3155: Select Pl_typ_Id
3156: From Ben_Pl_Typ_F
3157: Where Opt_typ_Cd = 'GSP'
3158: and P_Effective_Date
3159: Between Effective_Start_Date
3160: and Effective_End_Date

Line 3232: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_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;
3234: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3235: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3236: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;