DBA Data[Home] [Help]

APPS.ZPB_WF dependencies on FND_RESPONSIBILITY_VL

Line 2685: from zpb_account_states A, fnd_responsibility_vl R

2681: v_tasks c_Tasks%ROWTYPE;
2682: -- 5867453 bkport of 5371156 get resume parameters from zpb not wf
2683: CURSOR c_respID is
2684: select A.RESP_ID
2685: from zpb_account_states A, fnd_responsibility_vl R
2686: where A.ACCOUNT_STATUS = 0
2687: AND A.USER_ID = ownerID
2688: AND A.BUSINESS_AREA_ID = l_business_area_id
2689: AND A.RESP_ID = R.RESPONSIBILITY_ID

Line 3334: from zpb_analysis_cycles C, zpb_account_states A, fnd_responsibility_vl R

3330: -- 5867453 bkport of b5371156 new way to get params for setting context
3331: -- before submiting a request to the concurrent manager
3332: CURSOR c_owner_resp is
3333: select C.OWNER_ID, A.RESP_ID
3334: from zpb_analysis_cycles C, zpb_account_states A, fnd_responsibility_vl R
3335: where ANALYSIS_CYCLE_ID = Pacid
3336: AND A.ACCOUNT_STATUS = 0
3337: AND A.USER_ID = C.OWNER_ID
3338: AND C.BUSINESS_AREA_ID = A.BUSINESS_AREA_ID

Line 4497: from fnd_responsibility_vl

4493:
4494: -- Using ZPB_CONTROLLER_RESP as the source for this
4495: select RESPONSIBILITY_ID
4496: into respID
4497: from fnd_responsibility_vl
4498: where APPLICATION_ID = 210 and RESPONSIBILITY_KEY = 'ZPB_CONTROLLER_RESP';
4499:
4500: respAppID := 210; -- Hard coded for zpb
4501: