DBA Data[Home] [Help]

APPS.POR_RCV_TRANSACTION_SV dependencies on FND_USER

Line 95: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR

91:
92: BEGIN
93: SELECT HR.EMPLOYEE_ID
94: INTO x_employee_id
95: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
96: WHERE FND.USER_ID = x_user_id
97: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
98: AND ROWNUM = 1;
99: EXCEPTION

Line 96: WHERE FND.USER_ID = x_user_id

92: BEGIN
93: SELECT HR.EMPLOYEE_ID
94: INTO x_employee_id
95: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
96: WHERE FND.USER_ID = x_user_id
97: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
98: AND ROWNUM = 1;
99: EXCEPTION
100: WHEN others THEN