APPS.OZF_SD_REQUEST_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 588: FROM jtf_rs_resource_extns

584: AND ou.organization_id =p_org_id;
585:
586: CURSOR c_resource_id (p_user_id IN NUMBER) IS
587: SELECT resource_id
588: FROM jtf_rs_resource_extns
589: WHERE start_date_active <= sysdate
590: AND nvl(end_date_active,sysdate) >= sysdate
591: AND resource_id > 0
592: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')

Line 597: FROM jtf_rs_resource_extns

593: AND user_id = p_user_id;
594:
595: CURSOR c_requestor_id (p_requestor_id IN NUMBER) IS
596: SELECT resource_id
597: FROM jtf_rs_resource_extns
598: WHERE start_date_active <= sysdate
599: AND nvl(end_date_active,sysdate) >= sysdate
600: AND resource_id > 0
601: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')

Line 3976: FROM jtf_rs_resource_extns

3972: WHERE user_id =p_user_id;
3973:
3974: CURSOR c_resource_id (p_user_id IN NUMBER) IS
3975: SELECT resource_id
3976: FROM jtf_rs_resource_extns
3977: WHERE start_date_active <= sysdate
3978: AND nvl(end_date_active,sysdate) >= sysdate
3979: AND resource_id > 0
3980: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')

Line 5166: FROM jtf_rs_resource_extns

5162: AND org_id = p_org_id;
5163:
5164: CURSOR c_resource_id (p_user_id IN NUMBER) IS
5165: SELECT resource_id
5166: FROM jtf_rs_resource_extns
5167: WHERE start_date_active <= sysdate
5168: AND nvl(end_date_active,sysdate) >= sysdate
5169: AND resource_id > 0
5170: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')