APPS.IEX_COLLECTORS_TO_RESOURCE dependencies on JTF_RS_ROLES_B

Line 134: SELECT role_id from JTF_RS_ROLES_B WHERE ROLE_CODE = 'IEX_AGENT' and ROLE_TYPE_CODE = 'COLLECTIONS';

130: l_role_relate_id NUMBER;
131: l_responsibility_id NUMBER;
132:
133: CURSOR C_ROLE_ID IS
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

Line 252: jtf_rs_resource_extns jtfrs,JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv

248: BEGIN
249: SELECT 1
250: INTO l_check
251: FROM
252: jtf_rs_resource_extns jtfrs,JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv
253: WHERE
254: jtrr.role_resource_id = jtfrs.resource_id
255: AND jtv.role_id = jtrr.role_id
256: AND jtv.ROLE_CODE = 'IEX_AGENT'

Line 339: FROM JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv,

335: SELECT employee_id,inactive_date,description,name,resource_id FROM
336: ar_collectors ac
337: WHERE employee_id is not null
338: AND employee_id not in (SELECT jtr.source_id
339: FROM JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv,
340: JTF_RS_RESOURCE_EXTNS jtr
341: WHERE jtv.ROLE_CODE = 'IEX_AGENT' AND jtv.role_id = jtrr.role_id
342: AND jtrr.role_resource_id = jtr.resource_id
343: AND jtrr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'

Line 405: SELECT role_id from JTF_RS_ROLES_B WHERE ROLE_CODE = 'IEX_AGENT' and ROLE_TYPE_CODE = 'COLLECTIONS';

401: WHERE person_id = p_person_id
402: ORDER BY effective_start_date DESC;
403:
404: CURSOR C_ROLE_ID is
405: SELECT role_id from JTF_RS_ROLES_B WHERE ROLE_CODE = 'IEX_AGENT' and ROLE_TYPE_CODE = 'COLLECTIONS';
406:
407: l_colcount NUMBER; /* Counter for no. of collectors */
408:
409: CURSOR update_resource IS