APPS.JTF_TERRITORY_PVT dependencies on JTF_TYPE_QTYPE_USGS_ALL

Line 1329: SELECT QUAL_TYPE_USG_ID from JTF_TYPE_QTYPE_USGS_ALL WHERE terr_type_id = P_terr_type_id ;

1325: p_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
1326:
1327: CURSOR C_QUAL_TYPE_USG_ID (P_terr_type_id NUMBER)
1328: is
1329: SELECT QUAL_TYPE_USG_ID from JTF_TYPE_QTYPE_USGS_ALL WHERE terr_type_id = P_terr_type_id ;
1330:
1331: BEGIN
1332: --dbms_output('Create_Territory_Header PVT: Entering API');
1333: