APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 1362: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

1358: AND oeh.ship_to_org_id = nvl(p_party_site_id,oeh.ship_to_org_id)
1359: AND trunc(jspl.creation_date) between p_from_date and p_to_date
1360: AND EXISTS
1361: (SELECT 1
1362: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1363: JAI_CMN_TAXES_ALL jtc
1364: WHERE jtc.tax_id = jsptl.tax_id
1365: AND jsptl.delivery_detail_id = jspl.delivery_detail_id
1366: 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 1404: from JAI_OM_WSH_LINE_TAXES jsptl ,

1400: jsptl.UOM ,
1401: jsptl.TAX_AMOUNT ,
1402: jsptl.base_tax_amount ,
1403: jtc.stform_type
1404: from JAI_OM_WSH_LINE_TAXES jsptl ,
1405: JAI_CMN_TAXES_ALL jtc
1406: where delivery_detail_id in
1407: (
1408: select delivery_detail_id

Line 1447: FROM JAI_OM_WSH_LINE_TAXES

1443: function get_base_tax_amount(p_delivery_Detail_id number ,
1444: p_tax_id number) return number is
1445: cursor c_tax_amount (p_p1 number,p_p2 number,p_p3 number,p_p4 number,p_p5 number)is
1446: SELECT SUM(tax_amount)
1447: FROM JAI_OM_WSH_LINE_TAXES
1448: WHERE delivery_detail_id = p_delivery_Detail_id
1449: AND tax_line_no IN (p_p1,p_p2,p_p3,p_p4,p_p5);
1450:
1451: cursor c_get_precedences

Line 1458: from JAI_OM_WSH_LINE_TAXES

1454: precedence_2,
1455: precedence_3,
1456: precedence_4,
1457: precedence_5
1458: from JAI_OM_WSH_LINE_TAXES
1459: where delivery_detail_id = p_delivery_Detail_id
1460: and tax_id = p_tax_id;
1461:
1462: cursor c_get_line_amount