DBA Data[Home] [Help]

APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_DENORM_DEA_RULES_ALL

Line 573: from jty_denorm_dea_rules_all jtdr

569: and jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
570: and jtqu.qual_relation_product <> 1
571: and exists (
572: select /*+ index_ffs(jtdr jty_denorm_dea_rules_n1) */ 1
573: from jty_denorm_dea_rules_all jtdr
574: where jtdr.terr_id = jtqu.terr_id
575: and jtqu.terr_id = jtdr.related_terr_id );
576:
577: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;