DBA Data[Home] [Help]

APPS.OKE_UTILS dependencies on PER_ALL_PEOPLE_F

Line 7: G_Emp_ID per_all_people_f.person_id%type := NULL;

3:
4: --
5: -- Private Global Variables
6: --
7: G_Emp_ID per_all_people_f.person_id%type := NULL;
8: G_Emp_Name per_all_people_f.full_name%type := NULL;
9: G_User_ID fnd_user.user_id%type := NULL;
10: G_Yes VARCHAR2(80) := NULL;
11: G_No VARCHAR2(80) := NULL;

Line 8: G_Emp_Name per_all_people_f.full_name%type := NULL;

4: --
5: -- Private Global Variables
6: --
7: G_Emp_ID per_all_people_f.person_id%type := NULL;
8: G_Emp_Name per_all_people_f.full_name%type := NULL;
9: G_User_ID fnd_user.user_id%type := NULL;
10: G_Yes VARCHAR2(80) := NULL;
11: G_No VARCHAR2(80) := NULL;
12:

Line 100: FROM per_all_people_f

96: RETURN VARCHAR2 IS
97:
98: CURSOR csr ( c_person_id number ) IS
99: SELECT full_name
100: FROM per_all_people_f
101: WHERE person_id = c_person_id;
102:
103: BEGIN
104: --