DBA Data[Home] [Help]

APPS.ZPB_WF dependencies on ZPB_ACCOUNT_STATES

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