DBA Data[Home] [Help]

APPS.PV_PRGM_PMT_MODE_PVT dependencies on PV_LOOKUPS

Line 59: FROM pv_lookups lkp,

55: AND lkp.lookup_type = 'PAYMENT TYPE';
56:
57: CURSOR c_get_pv_prgm_pmt_mode(cv_program_payment_mode VARCHAR2, cv_program_id NUMBER, cv_program_geo_hierarchy_id NUMBER) IS
58: SELECT lkp.MEANING
59: FROM pv_lookups lkp,
60: PV_PROGRAM_PAYMENT_MODE pay_mode
61: WHERE lkp.LOOKUP_CODE = cv_program_payment_mode
62: AND pay_mode.PROGRAM_ID = cv_program_id
63: AND pay_mode.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id

Line 975: select meaning from pv_lookups

971: where LOCATION_HIERARCHY_ID = l_loc_hie_id;
972:
973: -- Cursor to get the meaning of paymentCode
974: CURSOR c_payment_code (l_payment_code IN VARCHAR2) IS
975: select meaning from pv_lookups
976: where lookup_type = 'PV_PAYMENT_TYPE'
977: and lookup_code = l_payment_code;
978:
979:

Line 1307: 'PV_LOOKUPS', -- Look up Table Name

1303:
1304: IF p_prgm_pmt_mode_rec.mode_type <> FND_API.g_miss_char THEN
1305:
1306: IF PVX_Utility_PVT.check_lookup_exists(
1307: 'PV_LOOKUPS', -- Look up Table Name
1308: 'PV_MODE_TYPE', -- Lookup Type
1309: p_prgm_pmt_mode_rec.mode_type -- Lookup Code
1310: ) = FND_API.g_false
1311: THEN