APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on AR_MEMO_LINES

Line 57: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null)

53: FUNCTION get_item_tax(
54: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
55: p_organization_id IN mtl_system_items.organization_id%TYPE,
56: p_trx_date IN DATE,
57: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null)
58: RETURN VARCHAR2;
59: /*******
60: -- Bug#3945805
61: FUNCTION get_location_tax(

Line 1770: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null

1766: FUNCTION get_item_tax (
1767: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
1768: p_organization_id IN mtl_system_items.organization_id%TYPE,
1769: p_trx_date IN DATE,
1770: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1771: ) RETURN VARCHAR2 IS
1772:
1773: -- l_tax_classification_code varchar2(30);
1774: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

Line 1777: c_memo_line_id AR_MEMO_LINES.memo_line_id%type,

1773: -- l_tax_classification_code varchar2(30);
1774: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1775:
1776: CURSOR sel_memo_line_tax(
1777: c_memo_line_id AR_MEMO_LINES.memo_line_id%type,
1778: c_trx_date DATE,
1779: c_org_id NUMBER)
1780: IS
1781: SELECT m.tax_code

Line 1782: -- FROM fnd_lookups l, AR_MEMO_LINES M bug#4574838

1778: c_trx_date DATE,
1779: c_org_id NUMBER)
1780: IS
1781: SELECT m.tax_code
1782: -- FROM fnd_lookups l, AR_MEMO_LINES M bug#4574838
1783: FROM zx_output_classifications_v l, AR_MEMO_LINES m
1784: WHERE m.memo_line_id = c_memo_line_id
1785: AND l.lookup_code = m.tax_code
1786: AND l.org_id IN (c_org_id, -99)

Line 1783: FROM zx_output_classifications_v l, AR_MEMO_LINES m

1779: c_org_id NUMBER)
1780: IS
1781: SELECT m.tax_code
1782: -- FROM fnd_lookups l, AR_MEMO_LINES M bug#4574838
1783: FROM zx_output_classifications_v l, AR_MEMO_LINES m
1784: WHERE m.memo_line_id = c_memo_line_id
1785: AND l.lookup_code = m.tax_code
1786: AND l.org_id IN (c_org_id, -99)
1787: AND l.enabled_flag = 'Y'