DBA Data[Home] [Help]

APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on FND_PROFILE

Line 261: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')

257: SELECT
258: ORGANIZATION_ID
259: FROM
260: ORG_ACCESS_VIEW
261: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
262: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
263: N := N + 1;
264: T_ORG_CODE_LIST(N) := C1.ORGANIZATION_ID;
265: END LOOP;

Line 262: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP

258: ORGANIZATION_ID
259: FROM
260: ORG_ACCESS_VIEW
261: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
262: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
263: N := N + 1;
264: T_ORG_CODE_LIST(N) := C1.ORGANIZATION_ID;
265: END LOOP;
266: LP_ALL_ORGS := 'Yes';