DBA Data[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 1146: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat

1142: declare
1143: cursor c_chk_ra_trx_tax_exists
1144: is
1145: select 1
1146: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat
1147: where line.tax_id = cat.tax_id
1148: and line.link_to_cust_trx_line_id = p_source_trx_line_id
1149: and cat.tax_category_id = p_threshold_tax_cat_id;
1150: begin

Line 1235: insert into JAI_AR_TRX_TAX_LINES

1231: , r_taxes.p_9
1232: , r_taxes.p_10
1233: );
1234: elsif p_source_event = jai_constants.bill_only_invoice then
1235: insert into JAI_AR_TRX_TAX_LINES
1236: (
1237: tax_line_no
1238: ,customer_trx_line_id
1239: ,link_to_cust_trx_line_id