APPS.POA_EDW_SPEND_PKG dependencies on POA_GA_UTIL_PKG

Line 14: IF (poa_ga_util_pkg.is_global_agreement(p_contract_id) = 'Y') THEN

10: v_stdpo_amt NUMBER := 0;
11: BEGIN
12:
13: IF (p_contract_type = 'BLANKET') THEN
14: IF (poa_ga_util_pkg.is_global_agreement(p_contract_id) = 'Y') THEN
15: SELECT SUM(decode( pol.matching_basis
16: , 'AMOUNT'
17: , (decode( pll.closed_code
18: , 'FINALLY_CLOSED'

Line 142: IF (poa_ga_util_pkg.is_global_agreement(p_contract_id) = 'Y') THEN

138: v_amt_released NUMBER := 0;
139: v_stdpo_amt NUMBER := 0;
140: BEGIN
141:
142: IF (poa_ga_util_pkg.is_global_agreement(p_contract_id) = 'Y') THEN
143: SELECT SUM(decode( pol.matching_basis
144: , 'AMOUNT'
145: , (decode( pll.closed_code
146: , 'FINALLY_CLOSED'

Line 230: IF (poa_ga_util_pkg.is_global_agreement(p_contract_id) = 'Y') THEN

226: v_qty_released NUMBER := 0;
227: v_stdpo_qty NUMBER := 0;
228: BEGIN
229:
230: IF (poa_ga_util_pkg.is_global_agreement(p_contract_id) = 'Y') THEN
231: SELECT SUM(decode(pll.closed_code, 'FINALLY_CLOSED',
232: (decode(sign(nvl(pod.quantity_delivered,0)
233: - nvl(pod.quantity_billed,0)),
234: 1, nvl(pod.quantity_delivered,0),nvl(pod.quantity_billed,0)))