APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_QUAL_USGS_ALL

Line 214: from jtf_qual_usgs_all jqua

210: l_index_name varchar2(30);
211:
212: cursor quals_used(cl_qual_relation_product number) is
213: select qual_usg_id
214: from jtf_qual_usgs_all jqua
215: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
216: and org_id = -3113;
217:
218: cursor qual_details(cl_qual_usg_id number) is

Line 219: select * from jtf_qual_usgs_all

215: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
216: and org_id = -3113;
217:
218: cursor qual_details(cl_qual_usg_id number) is
219: select * from jtf_qual_usgs_all
220: where qual_usg_id = cl_qual_usg_id
221: and org_id = -3113;
222:
223: BEGIN

Line 959: from jtf_qual_usgs_all jqua

955: l_header_seq NUMBER;
956:
957: cursor quals_used(cl_qual_relation_product number) is
958: select qual_usg_id
959: from jtf_qual_usgs_all jqua
960: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
961: and org_id = -3113;
962:
963: cursor qual_details(cl_qual_usg_id number) is

Line 964: select * from jtf_qual_usgs_all

960: where mod(cl_qual_relation_product, jqua.qual_relation_factor) = 0
961: and org_id = -3113;
962:
963: cursor qual_details(cl_qual_usg_id number) is
964: select * from jtf_qual_usgs_all
965: where qual_usg_id = cl_qual_usg_id
966: and org_id = -3113;
967:
968: BEGIN

Line 2030: FROM jtf_qual_usgs_all

2026: AND pf.qual_product_id = cl_set_S.qual_product_id
2027: ORDER BY f.input_selectivity)) ilv1,
2028: (
2029: SELECT qual_usg_id, 1 row_count
2030: FROM jtf_qual_usgs_all
2031: WHERE org_id = -3113
2032: AND seeded_qual_id = -1012) ilv2
2033: WHERE ilv1.qual_usg_id = ilv2.qual_usg_id
2034: AND ilv1.row_count = ilv2.row_count;

Line 2232: FROM jtf_qual_usgs_all

2228: AND pf.dea_attr_products_id = cl_set_S.dea_attr_products_id
2229: ORDER BY f.input_selectivity)) ilv1,
2230: (
2231: SELECT qual_usg_id, 1 row_count
2232: FROM jtf_qual_usgs_all
2233: WHERE org_id = -3113
2234: AND seeded_qual_id = -1012) ilv2
2235: WHERE ilv1.qual_usg_id = ilv2.qual_usg_id
2236: AND ilv1.row_count = ilv2.row_count;