[Home] [Help]
596: IF (g_asn_debug = 'Y') THEN
597: asn_debug.put_line('Defaulting tax name based on PO ' || TO_CHAR(default_po_info.tax_code_id));
598: END IF;
599:
600: -- Need to join to ap_tax_codes to get tax_name
601: BEGIN
602: SELECT NAME
603: INTO x_tax_name
604: FROM ap_tax_codes
600: -- Need to join to ap_tax_codes to get tax_name
601: BEGIN
602: SELECT NAME
603: INTO x_tax_name
604: FROM ap_tax_codes
605: WHERE ap_tax_codes.tax_id = default_po_info.tax_code_id;
606:
607: x_cascaded_table(n).tax_name := x_tax_name;
608: EXCEPTION
601: BEGIN
602: SELECT NAME
603: INTO x_tax_name
604: FROM ap_tax_codes
605: WHERE ap_tax_codes.tax_id = default_po_info.tax_code_id;
606:
607: x_cascaded_table(n).tax_name := x_tax_name;
608: EXCEPTION
609: WHEN OTHERS THEN