APPS.JTF_TAE_GEN_PVT dependencies on JTF_TERR_DENORM_RULES_ALL

Line 514: G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_newline ||

510: G_INDENT || ' , jtdr.top_level_terr_id ' || g_newline ||
511: G_INDENT || ' , jtdr.absolute_rank ' || g_newline ||
512: G_INDENT || ' , jtdr.num_winners ' || g_newline ||
513: G_INDENT || ' , jtdr.org_id ' || g_newline ||
514: G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_newline ||
515: G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_newline ||
516: G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || g_newline ||
517: G_INDENT || ' WHERE jtdr.source_id = p_source_id ' || g_newline ||
518: G_INDENT || ' AND jtdr.terr_id= jtdr.related_terr_id' || g_newline ||

Line 541: G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_newline ||

537: G_INDENT || ' , jtdr.top_level_terr_id ' || g_newline ||
538: G_INDENT || ' , jtdr.absolute_rank ' || g_newline ||
539: G_INDENT || ' , jtdr.num_winners ' || g_newline ||
540: G_INDENT || ' , jtdr.org_id ' || g_newline ||
541: G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_newline ||
542: G_INDENT || ' ,jtf_changed_terr_all jct ' || g_newline ||
543: G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_newline ||
544: G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || g_newline ||
545: G_INDENT || ' WHERE jqtu.source_id = p_source_id ' || g_newline ||

Line 3277: FROM jtf_terr_denorm_rules_all jtdr

3273:
3274: /* ARPATEL: 01/06/2004 bug#3337382 */
3275: CURSOR c_terr_rel_prod is
3276: SELECT jtdr.terr_id, jtqu.qual_relation_product
3277: FROM jtf_terr_denorm_rules_all jtdr
3278: ,jtf_terr_qtype_usgs_all jtqu
3279: ,jtf_qual_type_usgs_all jqtu
3280: ,jtf_changed_terr_all b
3281: WHERE jtdr.terr_id = jtdr.related_terr_id

Line 3297: /* get all the territory,relation_product from jtf_changed_terr_all,jtf_terr_denorm_rules_all

3293: RETURN;
3294:
3295: END IF;
3296:
3297: /* get all the territory,relation_product from jtf_changed_terr_all,jtf_terr_denorm_rules_all
3298: for the given qual_type_id */
3299: FOR JTF_csr in c_terr_rel_prod LOOP
3300:
3301: i := i + 1;

Line 3433: Add_To_PackageTable (' FROM jtf_terr_denorm_rules_all jtdr ');

3429: Add_To_PackageTable (' , jtdr.top_level_terr_id');
3430: Add_To_PackageTable (' , jtdr.absolute_rank ');
3431: Add_To_PackageTable (' , jtdr.num_winners ');
3432: Add_To_PackageTable (' , jtdr.org_id ');
3433: Add_To_PackageTable (' FROM jtf_terr_denorm_rules_all jtdr ');
3434: Add_To_PackageTable (' ,jtf_terr_qtype_usgs_all jtqu ');
3435: Add_To_PackageTable (' ,jtf_qual_type_usgs_all jqtu ');
3436: Add_To_PackageTable (' WHERE jtdr.source_id = p_source_id ');
3437: Add_To_PackageTable (' AND jtdr.resource_exists_flag= ''Y'' ');