APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on AR_MEMO_LINES

Line 646: l_line_type ar_memo_lines.line_type%type;

642: PROCEDURE expand_group_tax_code
643: (p_org_id IN NUMBER) IS
644:
645: l_index NUMBER := 0;
646: l_line_type ar_memo_lines.line_type%type;
647: l_application VARCHAR2(2);
648: l_delimiter zx_fc_types_b.delimiter%type;
649: l_delimiter_prod_cat zx_fc_types_b.delimiter%type;
650:

Line 990: -- Validate memo_line_id to AR_MEMO_LINES

986: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
987: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
988: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id);
989:
990: -- Validate memo_line_id to AR_MEMO_LINES
991: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id IS NOT NULL and nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7,1) <> 1 THEN
992: BEGIN
993: IF (g_level_statement >= g_current_runtime_level ) THEN
994: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Memo_lineId: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id||

Line 999: FROM ar_memo_lines_all_b ml --Bugfix 2367111

995: ' org_id: '||l_org_id);
996: END IF;
997: SELECT ml.line_type
998: INTO l_line_type
999: FROM ar_memo_lines_all_b ml --Bugfix 2367111
1000: WHERE ml.memo_line_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id
1001: AND nvl(ml.org_id,-99) = nvl(l_org_id,-99); --Bugfix 2367111
1002: EXCEPTION
1003: WHEN NO_DATA_FOUND THEN