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 1011: L_person_Id Per_All_People_F.Person_Id%TYPE;

1007: l_rate_value number;
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;

Line 2692: Per_All_People_F Person

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'
2694: and L_Effective_Date
2695: Between Ler.Effective_Start_Date
2696: and Ler.Effective_End_Date