APPS.ZPB_WF_NTF dependencies on FND_RESPONSIBILITY

Line 226: from fnd_responsibility_vl

222: else
223:
224: select RESPONSIBILITY_ID
225: into respID
226: from fnd_responsibility_vl
227: where APPLICATION_ID = appID and RESPONSIBILITY_KEY = RespKey;
228:
229: rolename := 'FND_RESP'|| appID || ':' || respID;
230: return rolename;

Line 287: from FND_RESPONSIBILITY A,

283:
284:
285: CURSOR c_baControllers is
286: select C.USER_NAME
287: from FND_RESPONSIBILITY A,
288: ZPB_ACCOUNT_STATES B,
289: FND_USER C
290: where B.BUSINESS_AREA_ID = l_business_area_id AND
291: A.RESPONSIBILITY_ID = B.RESP_ID AND

Line 299: from FND_RESPONSIBILITY A,

295: v_baControllers c_baControllers%ROWTYPE;
296:
297: CURSOR c_bpadmin is
298: select C.USER_NAME
299: from FND_RESPONSIBILITY A,
300: ZPB_ACCOUNT_STATES B,
301: FND_USER C
302: where A.RESPONSIBILITY_ID = B.RESP_ID AND
303: A.RESPONSIBILITY_KEY = 'ZPB_CONTROLLER_RESP' AND

Line 1696: from fnd_responsibility_vl

1692: -- add Responibility name as role dispaly name
1693: -- first get RESPONSIBILITY_ID
1694: select RESPONSIBILITY_ID, RESPONSIBILITY_NAME
1695: into l_respID, l_respDisplay
1696: from fnd_responsibility_vl
1697: where application_id = 210 and
1698: RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP';
1699:
1700: zpb_wf_ntf.SetRole(l_RoleName, 7, l_respDisplay);