APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PLIP_F

Line 150: Ben_Plip_F Plip,

146:
147: Cursor Dflt_grdldr is
148: Select Pgm.Pgm_Id
149: From Ben_Pgm_F Pgm,
150: Ben_Plip_F Plip,
151: Ben_Pl_F Plan
152: where Pgm.Dflt_Pgm_Flag = 'Y'
153: and Pgm.Pgm_Typ_Cd = 'GSP'
154: and P_effective_date

Line 558: from ben_plip_f plip,ben_pl_f pl

554: and paa.primary_flag ='Y'
555: and Paa.Grade_ladder_Pgm_Id is null
556: and Paa.grade_id in
557: (select pl.mapping_table_pk_id
558: from ben_plip_f plip,ben_pl_f pl
559: where plip.pgm_id = p_grade_ladder_id
560: and plip.pl_id = pl.pl_id
561: and L_Effective_Date between
562: plip.effective_start_date and plip.effective_end_date

Line 783: Ben_Plip_f Plip

779: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
780: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
781: from Ben_Pgm_F Pgm,
782: Ben_Pl_F Pl,
783: Ben_Plip_f Plip
784: Where Pgm.Pgm_Id = P_Pgm_Id
785: and P_Effective_Date
786: Between Pgm.Effective_Start_Date
787: and Pgm.Effective_End_Date

Line 1028: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;

1024: l_STRTD_DT DATE;
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;

Line 2417: Ben_PLip_F Plip,

2413: Asgt.Soft_Coding_Keyflex_Id, Asgt.Grade_Id, Asgt.Grade_Ladder_Pgm_Id
2414: From Ben_Elig_Per_Elctbl_Chc Enrlmt,
2415: Ben_Per_in_ler PIL,
2416: Ben_Pgm_F Pgm,
2417: Ben_PLip_F Plip,
2418: Ben_Pl_F Pl,
2419: Per_All_Assignments_F Asgt
2420: Where Enrlmt.Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_Id
2421: And Enrlmt.Per_In_Ler_id = Pil.Per_In_Ler_id

Line 2964: select plip_id from ben_plip_f

2960: and p_effective_date between pl.effective_start_date and pl.effective_end_date
2961: and pl.pl_stat_cd = 'A';
2962: --
2963: Cursor csr_grade_plip(p_pl_id in number, p_pgm_id in number) is
2964: select plip_id from ben_plip_f
2965: where pl_id = p_pl_id
2966: and pgm_id = p_pgm_id
2967: and business_group_id = p_business_group_id
2968: and p_effective_date between effective_start_date and effective_end_date

Line 2977: l_grade_plip ben_plip_f.plip_id%type := NULL;

2973: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2974: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2975: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2976: l_grade_pl ben_pl_f.pl_id%type := NULL;
2977: l_grade_plip ben_plip_f.plip_id%type := NULL;
2978: --
2979: Begin
2980: --
2981: hr_utility.set_location(' Entering get_persons_gl_and_grade', 10);

Line 3108: Ben_Plip_f Plip

3104: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
3105: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
3106: from Ben_Pgm_F Pgm,
3107: Ben_Pl_F Pl,
3108: Ben_Plip_f Plip
3109: Where Pgm.Pgm_Id = P_Pgm_Id
3110: and P_Effective_Date
3111: Between Pgm.Effective_Start_Date
3112: and Pgm.Effective_End_Date

Line 3228: L_plip_Id Ben_PLip_F.Plip_Id%TYPE;

3224: l_STRTD_DT DATE;
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;