45: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
46: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y';
47:
48:
49: --arp_standard.enable_debug;
50: EXCEPTION
51: WHEN OTHERS THEN
52: arp_standard.debug( 'Exception:');
53: end;
48:
49: --arp_standard.enable_debug;
50: EXCEPTION
51: WHEN OTHERS THEN
52: arp_standard.debug( 'Exception:');
53: end;
54:
55:
56:
109: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
110: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y';
111:
112:
113: --arp_standard.enable_debug;
114: EXCEPTION
115: WHEN OTHERS THEN
116: arp_standard.debug( 'Exception:');
117: end;
112:
113: --arp_standard.enable_debug;
114: EXCEPTION
115: WHEN OTHERS THEN
116: arp_standard.debug( 'Exception:');
117: end;
118:
119:
120: