APPS.IEX_COLLECTORS_TO_RESOURCE dependencies on FND_RESPONSIBILITY_VL

Line 138: SELECT RESPONSIBILITY_ID FROM fnd_responsibility_vl fr

134: SELECT role_id from JTF_RS_ROLES_B WHERE ROLE_CODE = 'IEX_AGENT' and ROLE_TYPE_CODE = 'COLLECTIONS';
135:
136: --Bug4930348. Use Responsibility Id. Fix by LKKUMAR on 16-Jan-2006. Start.
137: CURSOR C_RESPONSIBILITY IS
138: SELECT RESPONSIBILITY_ID FROM fnd_responsibility_vl fr
139: WHERE responsibility_name LIKE P_RESP;
140:
141:
142: CURSOR INSERT_RESOURCE IS

Line 144: from fnd_user_resp_groups furg, fnd_responsibility_vl fr, jtf_rs_resource_extns jtfrs

140:
141:
142: CURSOR INSERT_RESOURCE IS
143: SELECT jtfrs.resource_id,SOURCE_ID,SOURCE_NAME,jtfrs.user_name
144: from fnd_user_resp_groups furg, fnd_responsibility_vl fr, jtf_rs_resource_extns jtfrs
145: WHERE fr.responsibility_id = furg.responsibility_id
146: AND jtfrs.user_id = furg.user_id
147: AND furg.start_date < sysdate and (furg.end_date is null or furg.end_date > sysdate)
148: AND jtfrs.source_id is not null and jtfrs.user_id is not null