APPS.ZPB_AW_WRITE_BACK dependencies on FND_RESPONSIBILITY_VL

Line 115: resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%type;

111: P_OUTVAL OUT NOCOPY Number )
112: IS
113: req_id NUMBER;
114: req_nm ZPB_REQUESTS.req_name%type;
115: resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%type;
116: zpb_user FND_USER.USER_NAME%type;
117: stmt_ln NUMBER;
118: cmd_str VARCHAR2(32767);
119: spl_stmt ZPB_WRITEBACK_TRANSACTION.QDR%type;

Line 136: FROM FND_RESPONSIBILITY_VL

132: -- Added for Bug: 5475982
133: l_conc_request_id := fnd_global.conc_request_id;
134:
135: SELECT distinct(responsibility_name) into resp_name
136: FROM FND_RESPONSIBILITY_VL
137: WHERE responsibility_id = P_RESP_ID;
138:
139: SELECT distinct(user_name) into zpb_user
140: from FND_USER