APPS.JTF_RS_CONC_RES_PUB dependencies on FND_USER

Line 505: FROM fnd_user

501: CURSOR fetch_user_cur(l_employee_id NUMBER)
502: IS
503: SELECT user_id,
504: user_name
505: FROM fnd_user
506: WHERE employee_id = l_employee_id;
507:
508: cursor fetch_phone(l_person_id number)
509: is

Line 4240: FROM fnd_user fu

4236: IS
4237: BEGIN
4238: UPDATE jtf_rs_resource_extns res
4239: SET user_name = (SELECT user_name
4240: FROM fnd_user fu
4241: WHERE res.user_id = fu.user_id)
4242: WHERE user_id IS NOT NULL;
4243: COMMIT;
4244: EXCEPTION

Line 4278: FROM fnd_user f

4274: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4275: AND jres.USER_ID is not null
4276: AND NOT EXISTS
4277: ( SELECT 'x'
4278: FROM fnd_user f
4279: WHERE f.user_id = jres.user_id
4280: AND decode(category,'EMPLOYEE', employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id) = jres.source_id
4281: );
4282:

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

4279: WHERE f.user_id = jres.user_id
4280: AND decode(category,'EMPLOYEE', employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id) = jres.source_id
4281: );
4282:
4283: --to update effective FND_USER user_id during the period for the resource
4284: CURSOR c_invalid_active_userid IS
4285: SELECT
4286: RESOURCE_ID,
4287: CATEGORY,

Line 4300: FROM fnd_user f

4296: AND USER_ID is not null
4297: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4298: AND NOT EXISTS
4299: ( SELECT 'x'
4300: FROM fnd_user f
4301: WHERE f.user_id = jres.user_id
4302: AND decode(category,'EMPLOYEE', employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id) = jres.source_id
4303: AND trunc(sysdate) between trunc(start_date) and trunc(nvl(end_date,sysdate))
4304: );

Line 4323: from fnd_user f

4319: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4320: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4321: AND jres.USER_ID is null
4322: AND exists (select 'x'
4323: from fnd_user f
4324: where jres.source_id = decode(jres.category,'EMPLOYEE',
4325: employee_id,'SUPPLIER_CONTACT',supplier_id,customer_id)
4326: );
4327: */

Line 4343: from fnd_user f

4339: WHERE CATEGORY = 'EMPLOYEE'
4340: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4341: AND jres.USER_ID is null
4342: AND exists (select 'x'
4343: from fnd_user f
4344: where jres.source_id = employee_id)
4345: union all
4346: SELECT
4347: RESOURCE_ID,

Line 4360: from fnd_user f

4356: WHERE CATEGORY = 'SUPPLIER_CONTACT'
4357: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4358: AND jres.USER_ID is null
4359: AND exists (select 'x'
4360: from fnd_user f
4361: where jres.source_id = supplier_id)
4362: union all
4363: SELECT
4364: RESOURCE_ID,

Line 4377: from fnd_user f

4373: WHERE CATEGORY in ('PARTY','PARTNER')
4374: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4375: AND jres.USER_ID is null
4376: AND exists (select 'x'
4377: from fnd_user f
4378: where jres.source_id = customer_id);
4379:
4380: CURSOR c_party_partner(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) IS
4381: SELECT user_id,

Line 4383: FROM fnd_user

4379:
4380: CURSOR c_party_partner(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) IS
4381: SELECT user_id,
4382: user_name
4383: FROM fnd_user
4384: WHERE customer_id = p_source_id
4385: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
4386:
4387: CURSOR c_supp_contact(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is

Line 4390: FROM fnd_user

4386:
4387: CURSOR c_supp_contact(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
4388: SELECT user_id,
4389: user_name
4390: FROM fnd_user
4391: WHERE supplier_id = p_source_id
4392: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
4393:
4394: CURSOR c_emp(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is

Line 4397: FROM fnd_user

4393:
4394: CURSOR c_emp(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
4395: SELECT user_id,
4396: user_name
4397: FROM fnd_user
4398: WHERE employee_id = p_source_id
4399: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
4400:
4401: l_user_id fnd_user.user_id%type := NULL;

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

4397: FROM fnd_user
4398: WHERE employee_id = p_source_id
4399: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
4400:
4401: l_user_id fnd_user.user_id%type := NULL;
4402: l_user_name fnd_user.user_name%type := NULL;
4403: l_count number;
4404: i number;
4405:

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

4398: WHERE employee_id = p_source_id
4399: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
4400:
4401: l_user_id fnd_user.user_id%type := NULL;
4402: l_user_name fnd_user.user_name%type := NULL;
4403: l_count number;
4404: i number;
4405:
4406: BEGIN