DBA Data[Home] [Help]

APPS.WF_SOA_CTX_PKG dependencies on FND_RESPONSIBILITY_TL

Line 189: FROM FND_RESPONSIBILITY_TL T,

185: ELSE
186: --get from name
187: SELECT B.RESPONSIBILITY_ID
188: INTO pRespID
189: FROM FND_RESPONSIBILITY_TL T,
190: FND_RESPONSIBILITY B
191: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
192: AND B.APPLICATION_ID = T.APPLICATION_ID
193: AND T.LANGUAGE = pLangCode

Line 225: FROM FND_RESPONSIBILITY_TL T,

221:
222: --SELECT B.RESPONSIBILITY_ID
223: SELECT COUNT(*)
224: INTO nTemp
225: FROM FND_RESPONSIBILITY_TL T,
226: FND_RESPONSIBILITY B
227: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
228: AND B.APPLICATION_ID = T.APPLICATION_ID
229: AND T.LANGUAGE = pLangCode

Line 237: FROM FND_RESPONSIBILITY_TL T,

233: Raise No_data_Found;
234: elsif nTemp=1 Then
235: SELECT B.RESPONSIBILITY_ID, B.APPLICATION_ID
236: INTO pRespID, pRespAppID
237: FROM FND_RESPONSIBILITY_TL T,
238: FND_RESPONSIBILITY B
239: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
240: AND B.APPLICATION_ID = T.APPLICATION_ID
241: AND T.LANGUAGE = pLangCode