APPS.PV_ENRL_REQUEST_ORDER_PUB dependencies on PV_LOOKUPS

Line 5: --kvattiku: Aug 05, 05 Commented out for R12 in Get_payment_type. Directly retrieve from pv_lookups.

1: PACKAGE BODY PV_ENRL_REQUEST_ORDER_PUB AS
2: /* $Header: pvxperob.pls 120.1 2005/08/10 17:00:25 appldev ship $ */
3:
4: --Comments
5: --kvattiku: Aug 05, 05 Commented out for R12 in Get_payment_type. Directly retrieve from pv_lookups.
6: -- Added prefix ARPS to the AMOUNT_DUE_REMAINING column as it exists in
7: -- both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL
8:
9: -- Global constant holding the package name

Line 41: --kvattiku: Aug 05, 05 Directly retrieve from pv_lookups.

37: into v_payment_type_code, v_po_number
38: from oe_order_headers_all h
39: where h.header_id = p_order_header_id;
40:
41: --kvattiku: Aug 05, 05 Directly retrieve from pv_lookups.
42: if(v_payment_type_code is null) then
43: select meaning
44: into v_payment_type
45: from pv_lookups

Line 45: from pv_lookups

41: --kvattiku: Aug 05, 05 Directly retrieve from pv_lookups.
42: if(v_payment_type_code is null) then
43: select meaning
44: into v_payment_type
45: from pv_lookups
46: where lookup_type ='PV_PAYMENT_TYPE'
47: and lookup_code = 'INVOICE';
48: else
49: select meaning

Line 51: from pv_lookups

47: and lookup_code = 'INVOICE';
48: else
49: select meaning
50: into v_payment_type
51: from pv_lookups
52: where lookup_type ='PV_PAYMENT_TYPE'
53: and lookup_code = v_payment_type_code;
54: end if;
55: