APPS.EDW_DUNS_M_C dependencies on POA_DNB_SIC_CODE

Line 485: Update POA_DNB_SIC_CODE poa

481: END Push_EDW_DNB_TPRT;
482: */
483: -- Update the SIC Code Combination Table
484: edw_log.put_line('Updating SIC Code');
485: Update POA_DNB_SIC_CODE poa
486: set (SIC_Code,
487: SIC_Description,
488: DNB_Update_Date) =
489: (select distinct SIC_CODE_1,

Line 500: insert into POA_DNB_SIC_CODE poa (

496: where ((poa.SIC_Code = dnb.SIC_CODE_1) and
497: (poa.SIC_Description <> dnb.SIC_1_DESCRIPTION)));
498:
499: edw_log.put_line('Inserting SIC Code');
500: insert into POA_DNB_SIC_CODE poa (
501: SIC_Code,
502: SIC_Description,
503: DNB_Update_Date)
504: (select distinct SIC_CODE_1,

Line 509: from POA_DNB_SIC_CODE pdsc

505: SIC_1_DESCRIPTION,
506: sysdate from POA_TPRT_INTERFACE dnb
507: where NOT EXISTS
508: (select 'X'
509: from POA_DNB_SIC_CODE pdsc
510: where ltrim(rtrim(SIC_Code)) IS NOT NULL
511: and dnb.sic_code_1 = pdsc.sic_code));
512:
513:

Line 1440: from POA_DNB_SIC_CODE poa;

1436: SIC_DESCRIPTION,
1437: 'ALL',
1438: 'READY',
1439: 'Y'
1440: from POA_DNB_SIC_CODE poa;
1441:
1442: l_rows_inserted := sql%rowcount;
1443: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1444: edw_log.put_line('Commiting records for EDW_SICM_SIC_LSTG');