DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB dependencies on JTF_QUAL_USGS_ALL

Line 68: FROM JTF_QUAL_USGS_ALL partner

64: l_prtnr_qlfr_enabled VARCHAR2(1) ;
65:
66: CURSOR l_prtnr_qflr_csr(cv_prtnr_qualifier NUMBER) IS
67: SELECT nvl(partner.Enabled_Flag,'N')
68: FROM JTF_QUAL_USGS_ALL partner
69: WHERE partner.org_id= 204
70: AND partner.Seeded_Qual_Id = cv_prtnr_qualifier
71: AND partner.QUAL_TYPE_USG_ID=-1701 ;
72: