DBA Data[Home] [Help]

APPS.PO_EMPLOYEES_SV dependencies on FND_GLOBAL

Line 133: AND org.organization_id = fnd_global.org_id

129: AND P.EMPLOYEE_NUMBER IS NOT NULL) hr
130: WHERE FND.USER_ID = X_user_id
131: AND FND.EMPLOYEE_ID = hr.EMPLOYEE_ID
132: AND hr.set_of_books_id = org.set_of_books_id
133: AND org.organization_id = fnd_global.org_id
134: AND ROWNUM = 1;
135: EXCEPTION
136: WHEN OTHERS THEN
137: x_location_id := 0;

Line 205: AND org.organization_id = fnd_global.org_id

201: OR ps.actual_termination_date IS NULL )
202: AND fnd.user_id = TO_NUMBER(X_user_id)
203: AND fnd.employee_id = p.person_id
204: AND a.set_of_books_id = org.set_of_books_id
205: AND org.organization_id = fnd_global.org_id
206: UNION ALL
207: SELECT p.person_id employee_id,
208: p.full_name,
209: a.set_of_books_id,

Line 229: AND org.organization_id = fnd_global.org_id

225: OR pp.actual_termination_date IS NULL )
226: AND fnd.user_id = TO_NUMBER(X_user_id)
227: AND fnd.employee_id = p.person_id
228: AND a.set_of_books_id = org.set_of_books_id
229: AND org.organization_id = fnd_global.org_id
230: ) HR
231: WHERE ROWNUM = 1;
232: EXCEPTION
233: WHEN OTHERS THEN