APPS.IEX_COLLECTORS_TO_RESOURCE dependencies on FND_USER_RESP_GROUPS

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

Line 417: FND_USER_RESP_GROUPS FURG,

413: FU.USER_ID,
414: FU.EMPLOYEE_ID,
415: JRS.RESOURCE_ID
416: FROM
417: FND_USER_RESP_GROUPS FURG,
418: FND_RESPONSIBILITY FR ,
419: FND_USER FU,
420: JTF_RS_RESOURCE_EXTNS JRS
421: WHERE