eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PRTNR_PMNT_TYPES_PVT dependencies on PV_LOOKUPS

Line 7: -- 03-MAR-2003 sveerave changed lookup table from fnd_lookup_values to pv_lookups

3: -- Start of Comments
4: -- Package name: PV_PRTNR_PMNT_TYPES_PVT
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

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

Line 131: from pv_lookups

127:
128: CURSOR c_get_all_pmnt_modes IS
129: --kvattiku: Aug 05, 05 Modified to check for only the active codes
130: SELECT meaning, lookup_code
131: from pv_lookups
132: where lookup_type = 'PV_PAYMENT_TYPE'
133: and enabled_flag = 'Y'
134: and NVL(start_date_active, SYSDATE) <= SYSDATE
135: and NVL(end_date_active, SYSDATE) >= SYSDATE