DBA Data[Home] [Help]

APPS.PV_PRGM_PMT_MODE_PVT dependencies on OE_LOOKUPS

Line 50: FROM oe_lookups lkp,

46:
47: -- corrected the queries, logic for bug fix#2830585. -- sveerave,03/03/03
48: CURSOR c_get_oe_prgm_pmt_mode(cv_program_payment_mode VARCHAR2, cv_program_id NUMBER, cv_program_geo_hierarchy_id NUMBER) IS
49: SELECT lkp.MEANING
50: FROM oe_lookups lkp,
51: PV_PROGRAM_PAYMENT_MODE pay_mode
52: WHERE lkp.LOOKUP_CODE = cv_program_payment_mode
53: AND pay_mode.PROGRAM_ID = cv_program_id
54: AND pay_mode.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id