DBA Data[Home] [Help]

APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_DENORM_DEA_RULES_ALL

Line 371: from jty_denorm_dea_rules_all jtdr

367: and jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
368: and jtqu.qual_relation_product <> 1
369: and exists (
370: select /*+ index_ffs(jtdr jty_denorm_dea_rules_n1) */ 1
371: from jty_denorm_dea_rules_all jtdr
372: where jtdr.terr_id = jtqu.terr_id
373: and jtqu.terr_id = jtdr.related_terr_id );
374:
375: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;