APPS.EDW_TRD_PARTNER_M_C dependencies on EDW_TPRT_P2_TPARTNER_LSTG

Line 723: l_staging_table_name Varchar2(30) := 'EDW_TPRT_P2_TPARTNER_LSTG';

719: Procedure Push_P2_TPartner(Errbuf out NOCOPY Varchar2,
720: Retcode out NOCOPY Varchar2,
721: p_from_date Date := NULL,
722: p_to_date Date := NULL) IS
723: l_staging_table_name Varchar2(30) := 'EDW_TPRT_P2_TPARTNER_LSTG';
724: l_push_date_range1 Date := NULL;
725: l_push_date_range2 Date := NULL;
726: l_temp_date Date := NULL;
727: l_rows_inserted Number := 0;

Line 749: Insert Into EDW_TPRT_P2_TPARTNER_LSTG(

745: edw_log.put_line(' ');
746: edw_log.put_line('Pushing data for TP Parent 2 Staging Table...');
747:
748: l_temp_date := sysdate;
749: Insert Into EDW_TPRT_P2_TPARTNER_LSTG(
750: ALLOW_SUB_RECEIPT,
751: ALLOW_UNORDER_RCV,
752: ALTERNATE_NAME,
753: END_ACTIVE_DATE,