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 624: Ben_Ler_F Ler

620:
621:
622: Select Count(*) into L_Cnt
623: from Ben_Per_in_ler Pler,
624: Ben_Ler_F Ler
625: where Person_id = Asgt_Rec.Person_Id
626: and Per_In_ler_Stat_Cd = 'STRTD'
627: and Pler.Ler_Id = Ler.ler_ID
628: and Ler.Typ_Cd = 'GSP'

Line 761: from Ben_Ler_F

757: ,P_Elig_Per_Elctbl_Chc_Id OUT NOCOPY Number) is
758:
759: Cursor Life_Event_type(P_Business_Group_Id IN Number) is
760: Select Ler_id
761: from Ben_Ler_F
762: Where Typ_Cd = 'GSP'
763: and LF_EVT_OPER_CD = 'PROG' --ggnanagu 4032221
764: and P_Effective_Date
765: Between Effective_Start_Date

Line 1012: l_Ler_id Ben_ler_F.Ler_Id%TYPE;

1008: l_sal_value1 number;
1009: l_sal_value2 number;
1010:
1011: L_person_Id Per_All_People_F.Person_Id%TYPE;
1012: l_Ler_id Ben_ler_F.Ler_Id%TYPE;
1013: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
1014: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
1015: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
1016: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;

Line 1668: Ben_Ler_F LER

1664: --
1665: Cursor csr_prev_le is
1666: Select max(pil.Per_in_Ler_Id)
1667: From Ben_Per_in_ler PIL,
1668: Ben_Ler_F LER
1669: Where Pil.Ler_Id = LER.Ler_Id
1670: And ler.typ_Cd = 'GSP'
1671: And Pil.person_Id = l_person_id
1672: And Pil.Per_In_Ler_Stat_Cd = 'PROCD'

Line 1695: Ben_Ler_F LER

1691: Where Elct.DFLT_FLAG = 'Y'
1692: and Elct.Elctbl_Flag = 'Y'
1693: and Elct.Per_in_ler_id in (Select pil.Per_in_Ler_Id
1694: From Ben_Per_in_ler PIL,
1695: Ben_Ler_F LER
1696: Where Pil.Ler_Id = LER.Ler_Id
1697: And ler.typ_Cd = 'GSP'
1698: And Pil.person_Id = l_person_id
1699: And Pil.Per_In_Ler_Stat_Cd = 'PROCD'

Line 2689: Ben_Ler_F Ler,

2685: Cursor Elctbl is
2686: Select Elct.ELIG_PER_ELCTBL_CHC_ID, Pil.Person_Id, Pil.Per_In_Ler_id, Pil. Object_Version_Number,
2687: Elct.Enrt_Cvg_Strt_Dt, Pgm.Update_Salary_Cd, Pgm.Dflt_Step_Cd, Elct.Approval_Status_Cd, Person.Full_name
2688: From ben_Elig_Per_Elctbl_Chc Elct,
2689: Ben_Ler_F Ler,
2690: Ben_Per_in_ler Pil,
2691: Ben_Pgm_F PGM,
2692: Per_All_People_F Person
2693: where Ler.typ_Cd = 'GSP'