APPS.PQH_GSP_POST_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 109: l_Person_name Per_All_People_F.Full_name%TYPE;

105:
106: l_Pgm_Id BEN_PGM_F.Pgm_Id%TYPE;
107: l_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
108: l_Update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
109: l_Person_name Per_All_People_F.Full_name%TYPE;
110: l_Person_Id Per_All_People_F.Person_Id%TYPE;
111: l_Last_Name Per_All_People_F.Last_name%TYPE;
112: L_Cnt Number;
113: l_Grade_id Per_all_Assignments_F.Grade_Id%TYPE;

Line 110: l_Person_Id Per_All_People_F.Person_Id%TYPE;

106: l_Pgm_Id BEN_PGM_F.Pgm_Id%TYPE;
107: l_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
108: l_Update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
109: l_Person_name Per_All_People_F.Full_name%TYPE;
110: l_Person_Id Per_All_People_F.Person_Id%TYPE;
111: l_Last_Name Per_All_People_F.Last_name%TYPE;
112: L_Cnt Number;
113: l_Grade_id Per_all_Assignments_F.Grade_Id%TYPE;
114: l_Dflt_Step_Cd Ben_Pgm_F.Dflt_Step_Cd%TYPE;

Line 111: l_Last_Name Per_All_People_F.Last_name%TYPE;

107: l_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
108: l_Update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
109: l_Person_name Per_All_People_F.Full_name%TYPE;
110: l_Person_Id Per_All_People_F.Person_Id%TYPE;
111: l_Last_Name Per_All_People_F.Last_name%TYPE;
112: L_Cnt Number;
113: l_Grade_id Per_all_Assignments_F.Grade_Id%TYPE;
114: l_Dflt_Step_Cd Ben_Pgm_F.Dflt_Step_Cd%TYPE;
115: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;

Line 125: Per_All_People_F Person

121: Cursor Person_Dtls is
122: Select Full_name, Last_NAME, Person.Person_Id, Asgt.Grade_id, Asgt.Grade_Ladder_Pgm_Id
123: from Per_All_Assignments_F Asgt,
124: PER_ASSIGNMENT_STATUS_TYPES Pas,
125: Per_All_People_F Person
126: Where Assignment_Id = P_Assignment_Id
127: and P_Effective_Date
128: Between Asgt.Effective_Start_Date
129: and Asgt.Effective_End_Date

Line 910: L_person_Id Per_All_People_F.Person_Id%TYPE;

906: Between Effective_Start_Date
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;

Line 2532: Per_All_People_F Person

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'
2534: and L_Effective_Date
2535: Between Ler.Effective_Start_Date
2536: and Ler.Effective_End_Date