APPS.POR_LOAD_EMP_TEMP_TABLE dependencies on POR_EMPLOYEE_LOADER_VALUES

Line 27: UPDATE POR_EMPLOYEE_LOADER_VALUES

23:
24:
25: IF (get_employee_exists(x_employee_number)) THEN
26:
27: UPDATE POR_EMPLOYEE_LOADER_VALUES
28: SET
29: first_name = x_first_name,
30: last_name = x_last_name,
31: sex = x_sex,

Line 53: INSERT INTO POR_EMPLOYEE_LOADER_VALUES (

49:
50:
51: ELSE
52:
53: INSERT INTO POR_EMPLOYEE_LOADER_VALUES (
54: employee_number,
55: first_name,
56: last_name,
57: sex,

Line 114: SELECT 1 INTO l_exists FROM por_employee_loader_values

110: l_exists NUMBER;
111:
112: BEGIN
113:
114: SELECT 1 INTO l_exists FROM por_employee_loader_values
115: WHERE employee_number = p_employee_number;
116:
117: RETURN true;
118: