APPS.JTF_RS_CONC_RES_PUB dependencies on FND_USER

Line 447: FROM fnd_user

443: CURSOR fetch_user_cur(l_employee_id NUMBER)
444: IS
445: SELECT user_id,
446: user_name
447: FROM fnd_user
448: WHERE employee_id = l_employee_id;
449:
450: cursor fetch_phone(l_person_id number)
451: is

Line 3791: FROM fnd_user fu

3787: IS
3788: BEGIN
3789: UPDATE jtf_rs_resource_extns res
3790: SET user_name = (SELECT user_name
3791: FROM fnd_user fu
3792: WHERE res.user_id = fu.user_id)
3793: WHERE user_id IS NOT NULL;
3794: COMMIT;
3795: EXCEPTION

Line 3829: FROM fnd_user f

3825: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
3826: AND jres.USER_ID is not null
3827: AND NOT EXISTS
3828: ( SELECT 'x'
3829: FROM fnd_user f
3830: WHERE f.user_id = jres.user_id
3831: AND decode(category,'EMPLOYEE', employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id) = jres.source_id
3832: );
3833:

Line 3834: --to update effective FND_USER user_id during the period for the resource

3830: WHERE f.user_id = jres.user_id
3831: AND decode(category,'EMPLOYEE', employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id) = jres.source_id
3832: );
3833:
3834: --to update effective FND_USER user_id during the period for the resource
3835: CURSOR c_invalid_active_userid IS
3836: SELECT
3837: RESOURCE_ID,
3838: CATEGORY,

Line 3851: FROM fnd_user f

3847: AND USER_ID is not null
3848: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3849: AND NOT EXISTS
3850: ( SELECT 'x'
3851: FROM fnd_user f
3852: WHERE f.user_id = jres.user_id
3853: AND decode(category,'EMPLOYEE', employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id) = jres.source_id
3854: AND trunc(sysdate) between trunc(start_date) and trunc(nvl(end_date,sysdate))
3855: );

Line 3874: from fnd_user f

3870: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
3871: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3872: AND jres.USER_ID is null
3873: AND exists (select 'x'
3874: from fnd_user f
3875: where jres.source_id = decode(jres.category,'EMPLOYEE',
3876: employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id)
3877: );
3878: */

Line 3894: from fnd_user f

3890: WHERE CATEGORY = 'EMPLOYEE'
3891: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3892: AND jres.USER_ID is null
3893: AND exists (select 'x'
3894: from fnd_user f
3895: where jres.source_id = employee_id)
3896: union all
3897: SELECT
3898: RESOURCE_ID,

Line 3911: from fnd_user f

3907: WHERE CATEGORY = 'SUPPLIER_CONTACT'
3908: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3909: AND jres.USER_ID is null
3910: AND exists (select 'x'
3911: from fnd_user f
3912: where jres.source_id = supplier_id)
3913: union all
3914: SELECT
3915: RESOURCE_ID,

Line 3928: from fnd_user f

3924: WHERE CATEGORY in ('PARTY','PARTNER')
3925: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3926: AND jres.USER_ID is null
3927: AND exists (select 'x'
3928: from fnd_user f
3929: where jres.source_id = customer_id);
3930:
3931: CURSOR c_party_partner(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) IS
3932: SELECT user_id,

Line 3934: FROM fnd_user

3930:
3931: CURSOR c_party_partner(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) IS
3932: SELECT user_id,
3933: user_name
3934: FROM fnd_user
3935: WHERE customer_id = p_source_id
3936: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
3937:
3938: CURSOR c_supp_contact(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is

Line 3941: FROM fnd_user

3937:
3938: CURSOR c_supp_contact(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
3939: SELECT user_id,
3940: user_name
3941: FROM fnd_user
3942: WHERE supplier_id = p_source_id
3943: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
3944:
3945: CURSOR c_emp(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is

Line 3948: FROM fnd_user

3944:
3945: CURSOR c_emp(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
3946: SELECT user_id,
3947: user_name
3948: FROM fnd_user
3949: WHERE employee_id = p_source_id
3950: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
3951:
3952: l_user_id fnd_user.user_id%type := NULL;

Line 3952: l_user_id fnd_user.user_id%type := NULL;

3948: FROM fnd_user
3949: WHERE employee_id = p_source_id
3950: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
3951:
3952: l_user_id fnd_user.user_id%type := NULL;
3953: l_user_name fnd_user.user_name%type := NULL;
3954: l_count number;
3955: i number;
3956:

Line 3953: l_user_name fnd_user.user_name%type := NULL;

3949: WHERE employee_id = p_source_id
3950: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
3951:
3952: l_user_id fnd_user.user_id%type := NULL;
3953: l_user_name fnd_user.user_name%type := NULL;
3954: l_count number;
3955: i number;
3956:
3957: BEGIN