APPS.POA_EDW_CONTRACT_F_C dependencies on PO_HEADERS_ALL

Line 358: FROM PO_HEADERS_ALL

354: edw_log.put_line( 'Updated ' || p_count || ' records');
355:
356: INSERT INTO poa_edw_contract_inc(primary_key, seq_id)
357: SELECT po_header_id, l_seq_id
358: FROM PO_HEADERS_ALL
359: WHERE type_lookup_code in ('CONTRACT', 'BLANKET')
360: AND approved_flag = 'Y'
361: AND last_update_date between g_push_date_range1 and g_push_date_range2;
362:

Line 421: PO_HEADERS_ALL POH,

417: NVL(poh.currency_code,
418: gsob.currency_code)) From_Currency,
419: fstg.Collection_Status
420: FROM POA_EDW_CONTRACT_FSTG fstg,
421: PO_HEADERS_ALL POH,
422: GL_SETS_OF_BOOKS GSOB,
423: FINANCIALS_SYSTEM_PARAMS_ALL FSP
424: where (fstg.COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
425: fstg.COLLECTION_STATUS = 'INVALID CURRENCY')