APPS.IEX_COLLECTORS_TO_RESOURCE dependencies on FND_USER

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 377: ar_collectors ac, FND_USER fuser, per_all_people_f pemp ,hz_parties hp

373: hp.county,
374: hp.country,
375: hp.email_address
376: FROM
377: ar_collectors ac, FND_USER fuser, per_all_people_f pemp ,hz_parties hp
378: WHERE ac.employee_id is not null
379: AND ac.employee_id not in (SELECT jtr.source_id from
380: jtf_rs_resource_extns jtr where source_id is not null)
381: AND ac.resource_id is 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

Line 419: FND_USER FU,

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
422: FURG.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
423: AND JRS.SOURCE_ID = FU.EMPLOYEE_ID

Line 487: --UPdate the JTF_RS_RESOURCE_EXTNS Table with the value from FND_USER.

483: FOR i IN L_USER_ID.FIRST .. L_USER_ID.LAST
484: LOOP
485:
486: BEGIN
487: --UPdate the JTF_RS_RESOURCE_EXTNS Table with the value from FND_USER.
488: UPDATE JTF_RS_RESOURCE_EXTNS
489: SET USER_ID = L_USER_ID(i),
490: USER_NAME = L_USER_NAME(i),
491: last_update_date = SYSDATE,