[Home] [Help]
112: LH.STATE_REGION_NAME, 'CITY', LH.CITY_NAME,'POSTAL_CODE',
113: LH.POSTAL_CODE_START||'-'||LH.POSTAL_CODE_END) GEO_AREA_NAME,
114: LH.LOCATION_TYPE_NAME LOCATION_TYPE_NAME
115: FROM PV_PROGRAM_PAYMENT_MODE PPPMNT,
116: JTF_LOC_HIERARCHIES_VL LH
117: WHERE PPPMNT.PROGRAM_ID = cv_program_id
118: AND PPPMNT.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id
119: AND PPPMNT.MODE_OF_PAYMENT = cv_program_payment_mode
120: AND LH.LOCATION_HIERARCHY_ID = PPPMNT.GEO_HIERARCHY_ID
966: 'COUNTRY', LH.COUNTRY_NAME, 'CREGION', LH.COUNTRY_REGION_NAME,
967: 'STATE', LH.STATE_NAME, 'SREGION', LH.STATE_REGION_NAME, 'CITY', LH.CITY_NAME,
968: 'POSTAL_CODE', LH.POSTAL_CODE_START||'-'||LH.POSTAL_CODE_END, to_char(LOCATION_HIERARCHY_ID)),
969: LH.LOCATION_TYPE_NAME LOCATION_TYPE_NAME
970: from JTF_LOC_HIERARCHIES_VL LH
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
1270: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before GEO_HIERARCHY_ID fk check : GEO_HIERARCHY_ID ' || p_prgm_pmt_mode_rec.GEO_HIERARCHY_ID);
1271: END IF;
1272:
1273: IF PVX_Utility_PVT.check_fk_exists(
1274: 'JTF_LOC_HIERARCHIES_VL', -- Parent schema object having the primary key
1275: 'LOCATION_HIERARCHY_ID', -- Column name in the parent object that maps to the fk value
1276: p_prgm_pmt_mode_rec.GEO_HIERARCHY_ID, -- Value of fk to be validated against the parent object's pk column
1277: PVX_UTILITY_PVT.g_number, -- datatype of fk
1278: NULL