APPS.PV_PRTNR_PMNT_TYPES_PVT dependencies on PV_PROGRAM_PAYMENT_MODE

Line 9: -- jkylee added mode_type = 'PAYMENT' for PV_PROGRAM_PAYMENT_MODE for release12

5: -- Purpose :
6: -- History :
7: -- 03-MAR-2003 sveerave changed lookup table from fnd_lookup_values to pv_lookups
8: -- for bug fix# 2829104.
9: -- jkylee added mode_type = 'PAYMENT' for PV_PROGRAM_PAYMENT_MODE for release12
10: -- 31-MAR-2005 pukken support for Wire Transfer Enhancement 4137727
11: -- kvattiku Aug 31, 2005 Made changes to VerifyPaymentTypes api. Takes and extra input parameter
12: -- p_credit_card_exists which would be used to validate if credit card is
13: -- enabled in payments view.

Line 109: FROM PV_PROGRAM_PAYMENT_MODE

105:
106:
107: CURSOR c_pmnt_geo_hierarchy_ids IS
108: SELECT geo_hierarchy_id
109: FROM PV_PROGRAM_PAYMENT_MODE
110: where program_id is null
111: and MODE_TYPE='PAYMENT'
112: group by geo_hierarchy_id;
113:

Line 117: from pv_lookups l , PV_PROGRAM_PAYMENT_MODE p

113:
114: --kvattiku: Aug 05, 05
115: CURSOR c_get_pmnt_modes(l_geo_hierarchy_Id NUMBER) IS
116: SELECT meaning, lookup_code, mode_of_payment
117: from pv_lookups l , PV_PROGRAM_PAYMENT_MODE p
118: where l.lookup_type(+) = 'PV_PAYMENT_TYPE'
119: and l.enabled_flag(+) = 'Y'
120: and l.lookup_code(+) = p.mode_of_payment
121: and NVL(l.start_date_active, SYSDATE) <= SYSDATE