DBA Data[Home] [Help]

APPS.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_PDIST2

Line 82: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST2';

78: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST';
79: EXECUTE IMMEDIATE l_stmt;
80: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST1';
81: EXECUTE IMMEDIATE l_stmt;
82: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST2';
83: EXECUTE IMMEDIATE l_stmt;
84: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_SPERF';
85: EXECUTE IMMEDIATE l_stmt;
86: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RISK_IND';

Line 527: insert into POA_PORTAL_PDIST2 (

523: item.IORG_Purchaseable_Flag;
524:
525: p_count := p_count + sql%rowcount;
526:
527: insert into POA_PORTAL_PDIST2 (
528: SUM_PURCHASES,
529: SUM_LEAKAGE,
530: SUM_NON_CONTRACT,
531: SUPPLIER_PK_KEY,