APPS.PON_SUPPLIER_RESEARCH_PVT dependencies on STANDARD

Line 214: SELECT SUM(DECODE(type_lookup_code, 'STANDARD', 1,0)) total_spo,

210: l_txn_history_range_in_months := p_txn_history_range_in_months;
211: END IF;
212:
213: -- Fetch the po document totals
214: SELECT SUM(DECODE(type_lookup_code, 'STANDARD', 1,0)) total_spo,
215: SUM(DECODE(type_lookup_code, 'BLANKET', 1,0)) total_bpa,
216: SUM(DECODE(type_lookup_code, 'CONTRACT', 1,0)) total_cpa
217: INTO l_total_spo,
218: l_total_bpa,

Line 270: SELECT SUM(DECODE(type_lookup_code, 'STANDARD', 1,0)) total_spo,

266: l_txn_history_range_in_months := p_txn_history_range_in_months;
267: END IF;
268:
269: -- Fetch the po document totals
270: SELECT SUM(DECODE(type_lookup_code, 'STANDARD', 1,0)) total_spo,
271: SUM(DECODE(type_lookup_code, 'BLANKET', 1,0)) total_bpa,
272: SUM(DECODE(type_lookup_code, 'CONTRACT', 1,0)) total_cpa
273: INTO l_total_spo,
274: l_total_bpa,