DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on AP_TAX_CODES

Line 1017: -- Need to join to ap_tax_codes to get tax_name

1013: IF (g_asn_debug = 'Y') THEN
1014: asn_debug.put_line('Defaulting tax name based on PO ' || TO_CHAR(default_po_info.tax_code_id));
1015: END IF;
1016:
1017: -- Need to join to ap_tax_codes to get tax_name
1018: BEGIN
1019: SELECT NAME
1020: INTO x_tax_name
1021: FROM ap_tax_codes

Line 1021: FROM ap_tax_codes

1017: -- Need to join to ap_tax_codes to get tax_name
1018: BEGIN
1019: SELECT NAME
1020: INTO x_tax_name
1021: FROM ap_tax_codes
1022: WHERE ap_tax_codes.tax_id = default_po_info.tax_code_id;
1023:
1024: x_cascaded_table(n).tax_name := x_tax_name;
1025: EXCEPTION

Line 1022: WHERE ap_tax_codes.tax_id = default_po_info.tax_code_id;

1018: BEGIN
1019: SELECT NAME
1020: INTO x_tax_name
1021: FROM ap_tax_codes
1022: WHERE ap_tax_codes.tax_id = default_po_info.tax_code_id;
1023:
1024: x_cascaded_table(n).tax_name := x_tax_name;
1025: EXCEPTION
1026: WHEN OTHERS THEN