DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on JAI_BOE_ROUNDINGS

Line 396: FROM jai_boe_roundings jbr, jai_cmn_taxes_all jct

392: --------------------------------------------------------
393: CURSOR get_tax_amount_cur(pn_boe_id NUMBER) IS
394: SELECT jct.tax_type,
395: SUM(nvl(jbr.total_amount, jbr.tax_amount)) boe_amount
396: FROM jai_boe_roundings jbr, jai_cmn_taxes_all jct
397: WHERE jbr.boe_id = pn_boe_id
398: AND jbr.tax_id = jct.tax_id
399: GROUP BY jct.tax_type;
400: