APPS.OKE_DELIVERABLE_UTILS_PUB dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 142: FROM po_requisitions_interface_all

138: ;
139:
140: CURSOR d IS
141: SELECT Decode(process_flag, 'ERROR', G_NO, G_YES)
142: FROM po_requisitions_interface_all
143: WHERE oke_contract_deliverable_id = l_action_id AND batch_id = l_ref_1
144: ;
145:
146: CURSOR r IS

Line 297: FROM po_requisitions_interface_all

293: CURSOR d IS
294: SELECT 1
295: FROM dual
296: WHERE EXISTS ( SELECT 1
297: FROM po_requisitions_interface_all
298: WHERE oke_contract_deliverable_id = p_action_id
299: AND process_flag = 'ERROR');
300:
301: L_Value VARCHAR2(1);

Line 494: FROM po_requisitions_interface_all

490: FROM oke_deliverable_actions
491: WHERE pa_action_id = p_action_id
492: AND reference1 > 0
493: AND NOT EXISTS ( SELECT 1
494: FROM po_requisitions_interface_all
495: WHERE oke_contract_deliverable_id = p_action_id
496: AND process_flag = 'ERROR' );
497:
498: RETURN G_No;

Line 1278: FROM po_requisitions_interface_all

1274: WHERE b.deliverable_id = a.deliverable_id
1275: AND b.source_code = 'PA'
1276: AND ( a.reference1 is null OR EXISTS (
1277: SELECT 1
1278: FROM po_requisitions_interface_all
1279: WHERE oke_contract_deliverable_id > 0
1280: AND process_flag = 'ERROR'
1281: AND batch_id = a.reference1 ))
1282: AND NVL ( a.ready_flag, 'N' ) = 'Y'

Line 1297: FROM po_requisitions_interface_all

1293: AND b.source_code = 'PA'
1294: AND b.source_header_id = p_project_id
1295: AND ( a.reference1 is null OR EXISTS (
1296: SELECT 1
1297: FROM po_requisitions_interface_all
1298: WHERE oke_contract_deliverable_id > 0
1299: AND process_flag = 'ERROR'
1300: AND batch_id = a.reference1 ))
1301: AND NVL ( a.ready_flag, 'N' ) = 'Y'

Line 1316: FROM po_requisitions_interface_all

1312: AND b.source_code = 'PA'
1313: AND b.source_header_id = p_project_id
1314: AND ( a.reference1 is null OR EXISTS (
1315: SELECT 1
1316: FROM po_requisitions_interface_all
1317: WHERE oke_contract_deliverable_id > 0
1318: AND process_flag = 'ERROR'
1319: AND batch_id = a.reference1 ))
1320: AND NVL ( a.ready_flag, 'N' ) = 'Y'