APPS.OZF_SD_REQUEST_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 420: FROM jtf_rs_resource_extns

416: AND ou.organization_id =p_org_id;
417:
418: CURSOR c_resource_id (p_user_id IN NUMBER) IS
419: SELECT resource_id
420: FROM jtf_rs_resource_extns
421: WHERE start_date_active <= sysdate
422: AND nvl(end_date_active,sysdate) >= sysdate
423: AND resource_id > 0
424: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')

Line 429: FROM jtf_rs_resource_extns

425: AND user_id = p_user_id;
426:
427: CURSOR c_requestor_id (p_requestor_id IN NUMBER) IS
428: SELECT resource_id
429: FROM jtf_rs_resource_extns
430: WHERE start_date_active <= sysdate
431: AND nvl(end_date_active,sysdate) >= sysdate
432: AND resource_id > 0
433: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')

Line 3406: FROM jtf_rs_resource_extns

3402: WHERE user_id =p_user_id;
3403:
3404: CURSOR c_resource_id (p_user_id IN NUMBER) IS
3405: SELECT resource_id
3406: FROM jtf_rs_resource_extns
3407: WHERE start_date_active <= sysdate
3408: AND nvl(end_date_active,sysdate) >= sysdate
3409: AND resource_id > 0
3410: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')

Line 4581: FROM jtf_rs_resource_extns

4577: AND org_id = p_org_id;
4578:
4579: CURSOR c_resource_id (p_user_id IN NUMBER) IS
4580: SELECT resource_id
4581: FROM jtf_rs_resource_extns
4582: WHERE start_date_active <= sysdate
4583: AND nvl(end_date_active,sysdate) >= sysdate
4584: AND resource_id > 0
4585: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')