DBA Data[Home] [Help]

APPS.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_PDIST1

Line 80: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST1';

76:
77: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
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';

Line 467: insert into POA_PORTAL_PDIST1 (

463: item.IORG_Purchaseable_Flag;
464:
465: p_count := sql%rowcount;
466:
467: insert into POA_PORTAL_PDIST1 (
468: SUM_PURCHASES,
469: SUM_LEAKAGE,
470: SUM_NON_CONTRACT,
471: SUM_CONTRACT,