DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_CMN_TAXES_ALL

Line 1210: JAI_CMN_TAXES_ALL jtc

1206: nvl(jrtl.modvat_flag, 'N') modvatable /* Service */
1207: , nvl(tax_types.regime_code, 'XXXX') regime_code /* Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1208:
1209: from JAI_RCV_LINE_TAXES jrtl,
1210: JAI_CMN_TAXES_ALL jtc
1211: , jai_regime_tax_types_v tax_types /*Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1212: where jrtl.shipment_line_id = cp_shipment_line_id
1213: AND jrtl.tax_id = jtc.tax_id
1214: AND jtc.tax_type = tax_types.tax_type(+)

Line 2944: JAI_CMN_TAXES_ALL jtc

2940: , NVL(jtc.rounding_factor, 0)
2941: )--rchandan for bug#6971526 end
2942: ) tax_amount_by_account
2943: from JAI_RCV_LINE_TAXES jrtl,
2944: JAI_CMN_TAXES_ALL jtc
2945: where jrtl.shipment_line_id = cp_shipment_line_id
2946: and jrtl.tax_id = jtc.tax_id
2947: and ( nvl(jtc.mod_cr_percentage,0) between 0 and 100 ) --rchandan for bug#6971526
2948: and nvl(jrtl.modvat_flag, 'N') = 'Y'