APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 1222: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

1218: AND oeh.ship_to_org_id = nvl(p_party_site_id,oeh.ship_to_org_id)
1219: AND trunc(jspl.creation_date) between p_from_date and p_to_date
1220: AND EXISTS
1221: (SELECT 1
1222: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1223: JAI_CMN_TAXES_ALL jtc
1224: WHERE jtc.tax_id = jsptl.tax_id
1225: AND jsptl.delivery_detail_id = jspl.delivery_detail_id
1226: AND jtc.tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 1263: from JAI_OM_WSH_LINE_TAXES jsptl ,

1259: jsptl.UOM ,
1260: jsptl.TAX_AMOUNT ,
1261: jsptl.base_tax_amount ,
1262: jtc.stform_type
1263: from JAI_OM_WSH_LINE_TAXES jsptl ,
1264: JAI_CMN_TAXES_ALL jtc
1265: where delivery_detail_id in
1266: (
1267: select delivery_detail_id

Line 1306: FROM JAI_OM_WSH_LINE_TAXES

1302: function get_base_tax_amount(p_delivery_Detail_id number ,
1303: p_tax_id number) return number is
1304: cursor c_tax_amount (p_p1 number,p_p2 number,p_p3 number,p_p4 number,p_p5 number)is
1305: SELECT SUM(tax_amount)
1306: FROM JAI_OM_WSH_LINE_TAXES
1307: WHERE delivery_detail_id = p_delivery_Detail_id
1308: AND tax_line_no IN (p_p1,p_p2,p_p3,p_p4,p_p5);
1309:
1310: cursor c_get_precedences

Line 1317: from JAI_OM_WSH_LINE_TAXES

1313: precedence_2,
1314: precedence_3,
1315: precedence_4,
1316: precedence_5
1317: from JAI_OM_WSH_LINE_TAXES
1318: where delivery_detail_id = p_delivery_Detail_id
1319: and tax_id = p_tax_id;
1320:
1321: cursor c_get_line_amount