eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PL_F

Line 151: Ben_Pl_F Plan

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
155: Between Pgm.Effective_Start_Date

Line 517: from ben_plip_f plip,ben_pl_f pl

513: and paa.primary_flag ='Y'
514: and Paa.Grade_ladder_Pgm_Id is null
515: and Paa.grade_id in
516: (select pl.mapping_table_pk_id
517: from ben_plip_f plip,ben_pl_f pl
518: where plip.pgm_id = p_grade_ladder_id
519: and plip.pl_id = pl.pl_id
520: and L_Effective_Date between
521: plip.effective_start_date and plip.effective_end_date

Line 741: Ben_Pl_F Pl,

737: Cursor Ben_Grd_Dtls(P_Pgm_Id In Number, P_Grd_Id In Number) Is
738: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
739: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
740: from Ben_Pgm_F Pgm,
741: Ben_Pl_F Pl,
742: Ben_Plip_f Plip
743: Where Pgm.Pgm_Id = P_Pgm_Id
744: and P_Effective_Date
745: Between Pgm.Effective_Start_Date

Line 926: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;

922: l_PROCD_DT DATE;
923: l_STRTD_DT DATE;
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;

Line 954: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;

950: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_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:

Line 2258: Ben_Pl_F Pl,

2254: From Ben_Elig_Per_Elctbl_Chc Enrlmt,
2255: Ben_Per_in_ler PIL,
2256: Ben_Pgm_F Pgm,
2257: Ben_PLip_F Plip,
2258: Ben_Pl_F Pl,
2259: Per_All_Assignments_F Asgt
2260: Where Enrlmt.Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_Id
2261: And Enrlmt.Per_In_Ler_id = Pil.Per_In_Ler_id
2262: And Asgt.Person_id = PIL.Person_id

Line 2285: Ben_pl_F Pl,

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,
2289: Per_Spinal_point_Steps_F Step

Line 2317: L_PL_Id Ben_Pl_F.Pl_Id%TYPE;

2313: and P_Effective_Date
2314: Between Effective_Start_Date
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;

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 2816: l_grade_pl ben_pl_f.pl_id%type := NULL;

2812: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2813: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2814: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2815: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2816: l_grade_pl ben_pl_f.pl_id%type := NULL;
2817: l_grade_plip ben_plip_f.plip_id%type := NULL;
2818: --
2819: Begin
2820: --

Line 2947: Ben_Pl_F Pl,

2943: Cursor Ben_Grd_Dtls(P_Pgm_Id In Number, P_Grd_Id In Number) Is
2944: Select Pl.Pl_Id, plip.Plip_Id, Pgm.DFLT_STEP_CD,
2945: Pgm.UPDATE_SALARY_CD , DFLT_ELEMENT_TYPE_ID
2946: from Ben_Pgm_F Pgm,
2947: Ben_Pl_F Pl,
2948: Ben_Plip_f Plip
2949: Where Pgm.Pgm_Id = P_Pgm_Id
2950: and P_Effective_Date
2951: Between Pgm.Effective_Start_Date

Line 3067: L_Pl_id Ben_Pl_F.Pl_Id%TYPE;

3063: l_PROCD_DT DATE;
3064: l_STRTD_DT DATE;
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;

Line 3095: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;

3091: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_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