DBA Data[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 1243: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat

1239: declare
1240: cursor c_chk_ra_trx_tax_exists
1241: is
1242: select 1
1243: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat
1244: where line.tax_id = cat.tax_id
1245: and line.link_to_cust_trx_line_id = p_source_trx_line_id
1246: and cat.tax_category_id = p_threshold_tax_cat_id;
1247: begin

Line 1332: insert into JAI_AR_TRX_TAX_LINES

1328: , r_taxes.p_9
1329: , r_taxes.p_10
1330: );
1331: elsif p_source_event = jai_constants.bill_only_invoice then
1332: insert into JAI_AR_TRX_TAX_LINES
1333: (
1334: tax_line_no
1335: ,customer_trx_line_id
1336: ,link_to_cust_trx_line_id