APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PL_TYP_F

Line 789: From Ben_Pl_Typ_F

785: and Oipl.Effective_End_Date;
786:
787: Cursor PlanType is
788: Select Pl_typ_Id
789: From Ben_Pl_Typ_F
790: Where Opt_typ_Cd = 'GSP'
791: and P_Effective_Date
792: Between Effective_Start_Date
793: and Effective_End_Date;

Line 931: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_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;
933: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
934: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
935: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 2792: from ben_pl_f pl,ben_pl_typ_f pltyp

2788: and p_effective_date between effective_start_date and effective_end_date;
2789: --
2790: Cursor csr_grade_pl(p_grade_id in number) is
2791: select pl_id
2792: from ben_pl_f pl,ben_pl_typ_f pltyp
2793: where pltyp.business_group_id = p_business_group_id
2794: and pltyp.opt_typ_cd = 'GSP'
2795: and p_effective_date between pltyp.effective_start_date and pltyp.effective_end_date
2796: and pl.pl_typ_id = pltyp.pl_typ_id

Line 2996: From Ben_Pl_Typ_F

2992: and Oipl.Effective_End_Date;
2993:
2994: Cursor PlanType(p_business_group_id in number) is
2995: Select Pl_typ_Id
2996: From Ben_Pl_Typ_F
2997: Where Opt_typ_Cd = 'GSP'
2998: and P_Effective_Date
2999: Between Effective_Start_Date
3000: and Effective_End_Date

Line 3072: l_Pl_Typ_Id Ben_Pl_Typ_F.Pl_Typ_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;
3074: l_oipl_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
3075: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3076: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;