APPS.PV_PRGM_CONTRACTS_PVT dependencies on JTF_LOC_HIERARCHIES_VL

Line 757: from JTF_LOC_HIERARCHIES_VL LH

753: select DECODE(LH.LOCATION_TYPE_CODE, 'AREA1', LH.AREA1_NAME, 'AREA2',LH.AREA2_NAME,
754: 'COUNTRY', LH.COUNTRY_NAME, 'CREGION', LH.COUNTRY_REGION_NAME,
755: 'STATE', LH.STATE_NAME, 'SREGION', LH.STATE_REGION_NAME, 'CITY', LH.CITY_NAME,
756: 'POSTAL_CODE', LH.POSTAL_CODE_START||'-'||LH.POSTAL_CODE_END, to_char(LOCATION_HIERARCHY_ID))
757: from JTF_LOC_HIERARCHIES_VL LH
758: where LOCATION_HIERARCHY_ID = l_loc_hie_id;
759:
760: CURSOR c_get_program_contract_id (cv_program_id NUMBER, cv_geo_hierarchy_id NUMBER, cv_member_type_code VARCHAR2) IS
761: SELECT program_contracts_id

Line 1045: 'JTF_LOC_HIERARCHIES_VL', -- Parent schema object having the primary key

1041: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before GEO_HIERARCHY_ID fk check : GEO_HIERARCHY_ID ' || p_prgm_contracts_rec.GEO_HIERARCHY_ID);
1042: END IF;
1043:
1044: IF PVX_Utility_PVT.check_fk_exists(
1045: 'JTF_LOC_HIERARCHIES_VL', -- Parent schema object having the primary key
1046: 'LOCATION_HIERARCHY_ID', -- Column name in the parent object that maps to the fk value
1047: p_prgm_contracts_rec.GEO_HIERARCHY_ID, -- Value of fk to be validated against the parent object's pk column
1048: PVX_UTILITY_PVT.g_number, -- datatype of fk
1049: NULL