DBA Data[Home] [Help]

APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_AWT_TEMP_DISTRIBUTIONS_ALL

Line 648: INSERT INTO ap_awt_temp_distributions_all

644: l_bucket_wh_amount := l_bucket_wh_amount + l_prorated_base_withheld_amt;
645:
646: debug_info := 'Insert INTO ap_awt_temp_distributions';
647:
648: INSERT INTO ap_awt_temp_distributions_all
649: (invoice_id
650: ,payment_num
651: ,group_id
652: ,tax_name

Line 745: UPDATE ap_awt_temp_distributions_all

741: NVL(l_round_base_withheld_amt,0) <> 0 THEN
742:
743: --bug 8411621 modified the update statement by putting nvl.
744:
745: UPDATE ap_awt_temp_distributions_all
746: SET withholding_amount = (withholding_amount +
747: l_round_withheld_amt),
748: base_withholding_amount = (base_withholding_amount +
749: l_round_base_withheld_amt)

Line 789: insert into ap_awt_temp_distributions_all

785: --bug14288138
786: l_bucket_wh_amount := base_WT_amount;
787:
788: debug_info := 'Insert into ap_awt_temp_distributions';
789: insert into ap_awt_temp_distributions_all
790: (invoice_id
791: ,payment_num
792: ,group_id
793: ,tax_name