DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_BOE_DETAIL_TAXES

Line 1178: , 'jai_boe_detail_taxes'

1174: THEN
1175: lv_recalculation_sql :=
1176: replace ( lv_recalculation_sql
1177: , '$$TAX_SOURCE_TABLE$$'
1178: , 'jai_boe_detail_taxes'
1179: );
1180:
1181:
1182: lv_recalculation_sql :=

Line 3693: INSERT INTO jai_boe_detail_taxes

3689: ELSE
3690: lv_boe_flag := 'N';
3691: END IF;
3692: -- Add by Wenqiong for bug#12611347 end.
3693: INSERT INTO jai_boe_detail_taxes
3694: (boe_detail_tax_id,
3695: boe_detail_id,
3696: tax_line_no,
3697: precedence_1,

Line 3724: (jai_boe_detail_taxes_s.NEXTVAL,

3720: last_update_login,
3721: tax_category_id -- cbabu for EnhancementBug# 2427465
3722: )
3723: VALUES
3724: (jai_boe_detail_taxes_s.NEXTVAL,
3725: p_line_id,
3726: row_count,
3727: rec.p_1,
3728: rec.p_2,

Line 3759: UPDATE jai_boe_detail_taxes

3755: );
3756:
3757: ELSIF transaction_name = 'BOE_INVOICE_UPDATE' THEN
3758:
3759: UPDATE jai_boe_detail_taxes
3760: SET tax_amount = round(nvl(tax_amt_tab(row_count), 0),
3761: rec.rounding_factor),
3762: base_tax_amount = decode(nvl(base_tax_amt_tab(row_count), 0),
3763: 0,