APPS.PQH_GSP_POST_PROCESS dependencies on BEN_LER_F

Line 187: Ben_Ler_F LER

183:
184: Cursor csr_le is
185: Select max(pil.Per_in_Ler_Id)
186: From Ben_Per_in_ler PIL,
187: Ben_Ler_F LER
188: Where Pil.Ler_Id = LER.Ler_Id
189: And Pil.LF_EVT_OCRD_DT = P_Effective_Date
190: And ler.typ_Cd = 'GSP'
191: And Pil.person_Id = l_person_id

Line 207: Ben_Ler_F Ler

203:
204: Cursor Strtd_Le_Exits is
205: Select 'X'
206: from Ben_Per_in_ler Pler,
207: Ben_Ler_F Ler
208: where Person_id = l_Person_Id
209: and Per_In_ler_Stat_Cd = 'STRTD'
210: and Pler.Ler_Id = Ler.ler_ID
211: and Ler.Typ_Cd = 'GSP'

Line 583: Ben_Ler_F Ler

579:
580:
581: Select Count(*) into L_Cnt
582: from Ben_Per_in_ler Pler,
583: Ben_Ler_F Ler
584: where Person_id = Asgt_Rec.Person_Id
585: and Per_In_ler_Stat_Cd = 'STRTD'
586: and Pler.Ler_Id = Ler.ler_ID
587: and Ler.Typ_Cd = 'GSP'

Line 720: from Ben_Ler_F

716: ,P_Elig_Per_Elctbl_Chc_Id OUT NOCOPY Number) is
717:
718: Cursor Life_Event_type(P_Business_Group_Id IN Number) is
719: Select Ler_id
720: from Ben_Ler_F
721: Where Typ_Cd = 'GSP'
722: and LF_EVT_OPER_CD = 'PROG' --ggnanagu 4032221
723: and P_Effective_Date
724: Between Effective_Start_Date

Line 911: l_Ler_id Ben_ler_F.Ler_Id%TYPE;

907: and Effective_End_Date
908: and Business_Group_id = Hr_general.get_business_group_id;
909:
910: L_person_Id Per_All_People_F.Person_Id%TYPE;
911: l_Ler_id Ben_ler_F.Ler_Id%TYPE;
912: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
913: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
914: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
915: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;

Line 1508: Ben_Ler_F LER

1504: --
1505: Cursor csr_prev_le is
1506: Select max(pil.Per_in_Ler_Id)
1507: From Ben_Per_in_ler PIL,
1508: Ben_Ler_F LER
1509: Where Pil.Ler_Id = LER.Ler_Id
1510: And ler.typ_Cd = 'GSP'
1511: And Pil.person_Id = l_person_id
1512: And Pil.Per_In_Ler_Stat_Cd = 'PROCD'

Line 1535: Ben_Ler_F LER

1531: Where Elct.DFLT_FLAG = 'Y'
1532: and Elct.Elctbl_Flag = 'Y'
1533: and Elct.Per_in_ler_id in (Select pil.Per_in_Ler_Id
1534: From Ben_Per_in_ler PIL,
1535: Ben_Ler_F LER
1536: Where Pil.Ler_Id = LER.Ler_Id
1537: And ler.typ_Cd = 'GSP'
1538: And Pil.person_Id = l_person_id
1539: And Pil.Per_In_Ler_Stat_Cd = 'PROCD'

Line 2529: Ben_Ler_F Ler,

2525: Cursor Elctbl is
2526: Select Elct.ELIG_PER_ELCTBL_CHC_ID, Pil.Person_Id, Pil.Per_In_Ler_id, Pil. Object_Version_Number,
2527: Elct.Enrt_Cvg_Strt_Dt, Pgm.Update_Salary_Cd, Pgm.Dflt_Step_Cd, Elct.Approval_Status_Cd, Person.Full_name
2528: From ben_Elig_Per_Elctbl_Chc Elct,
2529: Ben_Ler_F Ler,
2530: Ben_Per_in_ler Pil,
2531: Ben_Pgm_F PGM,
2532: Per_All_People_F Person
2533: where Ler.typ_Cd = 'GSP'