APPS.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_SPERF

Line 84: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_SPERF';

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';
87: EXECUTE IMMEDIATE l_stmt;
88: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RISK_SUMMARY';

Line 123: INSERT into POA_PORTAL_SPERF (

119: p_count OUT NOCOPY NUMBER,
120: success OUT NOCOPY varchar2) IS
121: BEGIN
122:
123: INSERT into POA_PORTAL_SPERF (
124: NUM_LATE_RCPT,
125: NUM_RCPT_LINES,
126: AVG_Rcpt_Late_Days,
127: Max_Days_Lt,

Line 262: from poa_portal_sperf

258: 0 open_payments,
259: 0 open_pay_age,
260: 0 late_supplier_conf,
261: 0 late_conf_age
262: from poa_portal_sperf
263: group by operating_unit_pk_key,
264: operating_unit_name
265: UNION ALL
266: select operating_unit_pk_key,