DBA Data[Home] [Help]

APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on FND_PROFILE

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

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

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

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