APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_DENORM_RULES_ALL

Line 559: from jtf_terr_denorm_rules_all jtdr

555: and jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
556: and jtqu.qual_relation_product <> 1
557: and exists (
558: select /*+ index_ffs(jtdr jtf_terr_denorm_rules_n1) */ 1
559: from jtf_terr_denorm_rules_all jtdr
560: where jtdr.terr_id = jtqu.terr_id
561: and jtqu.terr_id = jtdr.related_terr_id );
562:
563: CURSOR c_dea_qual_rel_sets(cl_source_id number, cl_qual_type_id number) is

Line 1138: -- Update theabsolute rank in jtf_terr_denorm_rules_all for all service territories when the STAR is run for Service.

1134: FROM jtf_sources_all
1135: WHERE source_id = p_source_id;
1136: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
1137:
1138: -- Update theabsolute rank in jtf_terr_denorm_rules_all for all service territories when the STAR is run for Service.
1139: IF (p_source_id = -1002) THEN
1140: UPDATE jtf_terr_denorm_rules_all jtda
1141: SET absolute_rank = ( select absolute_rank from jtf_terr_all jta where jta.terr_id = jtda.terr_id)
1142: where jtda.source_id = -1002;

Line 1140: UPDATE jtf_terr_denorm_rules_all jtda

1136: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
1137:
1138: -- Update theabsolute rank in jtf_terr_denorm_rules_all for all service territories when the STAR is run for Service.
1139: IF (p_source_id = -1002) THEN
1140: UPDATE jtf_terr_denorm_rules_all jtda
1141: SET absolute_rank = ( select absolute_rank from jtf_terr_all jta where jta.terr_id = jtda.terr_id)
1142: where jtda.source_id = -1002;
1143: END IF;
1144: