APPS.IEU_WR_PUB dependencies on JTF_OBJECTS_B

Line 214: FROM jtf_objects_b

210:
211: BEGIN
212: SELECT object_code, object_function
213: INTO l_workitem_obj_code, l_object_function
214: FROM jtf_objects_b
215: WHERE object_code = p_workitem_obj_code;
216: EXCEPTION
217: WHEN no_data_found THEN
218: null;

Line 1237: FROM jtf_objects_b

1233:
1234: BEGIN
1235: SELECT 1
1236: INTO l_workitem_obj_code
1237: FROM jtf_objects_b
1238: WHERE object_code = p_workitem_obj_code;
1239: EXCEPTION
1240: WHEN no_data_found THEN
1241: null;

Line 3371: FROM jtf_objects_b

3367:
3368: BEGIN
3369: SELECT object_code, object_function
3370: INTO l_workitem_obj_code, l_object_function
3371: FROM jtf_objects_b
3372: WHERE object_code = p_workitem_obj_code;
3373: EXCEPTION
3374: WHEN no_data_found THEN
3375: null;

Line 4864: FROM jtf_objects_b

4860:
4861: BEGIN
4862: SELECT 1
4863: INTO l_workitem_obj_code
4864: FROM jtf_objects_b
4865: WHERE object_code = p_workitem_obj_code;
4866: EXCEPTION
4867: WHEN no_data_found THEN
4868: null;

Line 6251: FROM jtf_objects_b

6247:
6248: BEGIN
6249: SELECT object_code, object_function
6250: INTO l_workitem_obj_code, l_object_function
6251: FROM jtf_objects_b
6252: WHERE object_code = p_workitem_obj_code;
6253: EXCEPTION
6254: WHEN no_data_found THEN
6255: null;

Line 9558: FROM jtf_objects_b

9554:
9555: BEGIN
9556: SELECT 1
9557: INTO l_workitem_obj_code
9558: FROM jtf_objects_b
9559: WHERE object_code = p_object_type;
9560: EXCEPTION
9561: WHEN no_data_found THEN
9562: null;

Line 9840: FROM jtf_objects_b

9836:
9837: BEGIN
9838: SELECT 1
9839: INTO l_workitem_obj_code
9840: FROM jtf_objects_b
9841: WHERE object_code = p_workitem_obj_code;
9842: EXCEPTION
9843: WHEN no_data_found THEN
9844: null;

Line 10666: FROM JTF_OBJECTS_B

10662: FROM IEU_UWQM_ITEMS_GTT A
10663: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10664: AND NOT EXISTS
10665: ( SELECT 1
10666: FROM JTF_OBJECTS_B
10667: WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE );
10668:
10669: IF NVL(l_count, 0) > 0
10670: THEN

Line 10681: FROM JTF_OBJECTS_B

10677: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10678: AND ROWNUM <= 5
10679: AND NOT EXISTS
10680: ( SELECT 1
10681: FROM JTF_OBJECTS_B
10682: WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE );
10683:
10684: FOR i IN WORKITEM_PK_ID_LIST.FIRST..WORKITEM_PK_ID_LIST.LAST
10685: LOOP