APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_QUAL_USGS_ALL

Line 259: from jtf_qual_usgs_all jqua

255: l_index_name varchar2(30);
256:
257: cursor quals_used(cl_qual_relation_product number) is
258: select qual_usg_id
259: from jtf_qual_usgs_all jqua
260: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
261: and org_id = -3113;
262:
263: cursor qual_details(cl_qual_usg_id number) is

Line 264: select * from jtf_qual_usgs_all

260: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
261: and org_id = -3113;
262:
263: cursor qual_details(cl_qual_usg_id number) is
264: select * from jtf_qual_usgs_all
265: where qual_usg_id = cl_qual_usg_id
266: and org_id = -3113;
267:
268: BEGIN

Line 990: from jtf_qual_usgs_all jqua

986: l_header_seq NUMBER;
987:
988: cursor quals_used(cl_qual_relation_product number) is
989: select qual_usg_id
990: from jtf_qual_usgs_all jqua
991: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
992: and org_id = -3113;
993:
994: cursor qual_details(cl_qual_usg_id number) is

Line 995: select * from jtf_qual_usgs_all

991: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
992: and org_id = -3113;
993:
994: cursor qual_details(cl_qual_usg_id number) is
995: select * from jtf_qual_usgs_all
996: where qual_usg_id = cl_qual_usg_id
997: and org_id = -3113;
998:
999: BEGIN

Line 2046: FROM jtf_qual_usgs_all

2042: AND pf.qual_product_id = cl_set_S.qual_product_id
2043: ORDER BY f.input_selectivity)) ilv1,
2044: (
2045: SELECT qual_usg_id, 1 row_count
2046: FROM jtf_qual_usgs_all
2047: WHERE org_id = -3113
2048: AND seeded_qual_id = -1012) ilv2
2049: WHERE ilv1.qual_usg_id = ilv2.qual_usg_id
2050: AND ilv1.row_count = ilv2.row_count;

Line 2242: FROM jtf_qual_usgs_all

2238: AND pf.dea_attr_products_id = cl_set_S.dea_attr_products_id
2239: ORDER BY f.input_selectivity)) ilv1,
2240: (
2241: SELECT qual_usg_id, 1 row_count
2242: FROM jtf_qual_usgs_all
2243: WHERE org_id = -3113
2244: AND seeded_qual_id = -1012) ilv2
2245: WHERE ilv1.qual_usg_id = ilv2.qual_usg_id
2246: AND ilv1.row_count = ilv2.row_count;