APPS.POA_EDW_CONTRACT_F_C dependencies on POA_EDW_CONTRACT_FSTG

Line 44: FROM POA_EDW_CONTRACT_FSTG

40: IS
41: BEGIN
42: INSERT INTO poa_edw_contract_inc(primary_key)
43: SELECT po_header_id
44: FROM POA_EDW_CONTRACT_FSTG
45: where COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
46: COLLECTION_STATUS = 'INVALID CURRENCY';
47:
48: IF (sql%rowcount > 0) THEN

Line 68: DELETE FROM POA_EDW_CONTRACT_FSTG

64: -- collection status of either rate not available or invalid currency.
65: PROCEDURE DELETE_STG_MISSING_RATES
66: IS
67: BEGIN
68: DELETE FROM POA_EDW_CONTRACT_FSTG
69: WHERE COLLECTION_STATUS = 'RATE NOT AVAILABLE'
70: OR COLLECTION_STATUS = 'INVALID CURRENCY'
71: AND INSTANCE_FK = (SELECT INSTANCE_CODE
72: FROM EDW_LOCAL_INSTANCE);

Line 102: Insert Into POA_EDW_CONTRACT_FSTG(

98: edw_log.put_line(' ');
99: edw_log.put_line('Pushing data to local staging table...');
100:
101: l_temp_date := sysdate;
102: Insert Into POA_EDW_CONTRACT_FSTG(
103: DUNS_FK,
104: SIC_CODE_FK,
105: CONTRACT_NUM,
106: ACCPT_DUE_DATE_FK,

Line 389: l_staging_table Varchar2(30) := 'POA_EDW_CONTRACT_FSTG';

385: p_from_date IN Varchar2,
386: p_to_date IN Varchar2) IS
387:
388: l_fact_name Varchar2(30) := 'POA_EDW_CONTRACT_F';
389: l_staging_table Varchar2(30) := 'POA_EDW_CONTRACT_FSTG';
390:
391: -- -------------------------------------------
392: -- Put any additional developer variables here
393: -- -------------------------------------------

Line 420: FROM POA_EDW_CONTRACT_FSTG fstg,

416: 'User',gsob.currency_code,
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