APPS.POR_LOAD_EMPLOYEE dependencies on PER_ALL_PEOPLE_F

Line 52: p_Last_Name PER_ALL_PEOPLE_F.LAST_NAME%TYPE;

48: p_Effective_Start_Date DATE;
49: p_Effective_End_Date DATE;
50: p_Business_Group_Id NUMBER;
51: p_Person_Type_Id NUMBER;
52: p_Last_Name PER_ALL_PEOPLE_F.LAST_NAME%TYPE;
53: p_Start_Date DATE;
54: p_Hire_date DATE;
55: p_S_Hire_Date DATE;
56: p_Period_of_service_id NUMBER;

Line 68: p_First_Name PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;

64: p_Date_Employee_Data_Verified DATE;
65: p_Date_Of_Birth DATE;
66: p_Email_Address VARCHAR2(240);
67: p_Expense_Check_To_Address VARCHAR2(30);
68: p_First_Name PER_ALL_PEOPLE_F.FIRST_NAME%TYPE;
69: p_Full_Name VARCHAR2(240);
70: p_Known_As VARCHAR2(30);
71: p_Marital_Status VARCHAR2(30);
72: p_Middle_Names VARCHAR2(30);

Line 75: p_Previous_Last_Name PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE;

71: p_Marital_Status VARCHAR2(30);
72: p_Middle_Names VARCHAR2(30);
73: p_Nationality VARCHAR2(30);
74: p_National_Identifier VARCHAR2(30);
75: p_Previous_Last_Name PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE;
76: p_Registered_Disabled_Flag VARCHAR2(30);
77: p_Sex VARCHAR2(30);
78: p_Title VARCHAR2(30);
79: p_Vendor_Id NUMBER(30);

Line 353: FROM per_all_people_f

349:
350: BEGIN
351:
352: SELECT person_id INTO l_person_id
353: FROM per_all_people_f
354: WHERE employee_number = p_employee_number;
355:
356: RETURN l_person_id;
357:

Line 370: FROM per_all_people_f

366:
367: BEGIN
368:
369: SELECT rowid INTO l_row_id
370: FROM per_all_people_f
371: WHERE employee_number = p_employee_number;
372:
373: RETURN l_row_id;
374:

Line 576: FROM per_all_people_f

572: p_Attribute30,
573: p_Last_Update_Date,
574: p_Last_Updated_By,
575: p_Last_Update_Login
576: FROM per_all_people_f
577: WHERE EMPLOYEE_NUMBER = x_employee_number;
578:
579: END get_employee_details;
580: