APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_QUAL_ALL

Line 1089: ,jtf_terr_qual_all jtq

1085: AND v.qual_type_id = lp_trans_id
1086: AND EXISTS ( SELECT jtq.terr_id
1087: FROM jtf_terr_qtype_usgs_all jtqu
1088: ,jtf_terr_all jt
1089: ,jtf_terr_qual_all jtq
1090: ,jtf_qual_type_usgs jqtu
1091: WHERE jt.end_date_active >= lp_start_date
1092: AND jt.start_date_active <= lp_end_date
1093: AND jtqu.terr_id = jt.terr_id

Line 1311: l_qual_rules := l_qual_rules || l_newline || ' , jtf_terr_values_all jtv, jtf_terr_denorm_rules_all B, jtf_terr_qual_all jtq ';

1307: l_qual_rules := l_qual_rules || l_newline || ' UNION ALL ' || l_newline;
1308: END IF;
1309: l_qual_rules := l_qual_rules || l_rts_tbl(j) || l_newline || ' FROM ' || l_trans_name_tbl(i) || ' A ';
1310: /* add the denorm value table name */
1311: l_qual_rules := l_qual_rules || l_newline || ' , jtf_terr_values_all jtv, jtf_terr_denorm_rules_all B, jtf_terr_qual_all jtq ';
1312: IF (l_rtf_tbl(j) IS NOT NULL) THEN
1313: l_qual_rules := l_qual_rules || l_newline || ' ,' || l_rtf_tbl(j) || ' ';
1314: END IF;
1315: l_qual_rules := l_qual_rules || l_newline || l_rtw_tbl(j) || l_newline || ' ';