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 1784: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null

1780: FUNCTION get_item_tax (
1781: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
1782: p_organization_id IN mtl_system_items.organization_id%TYPE,
1783: p_trx_date IN DATE,
1784: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1785: ) RETURN VARCHAR2 IS
1786:
1787: -- l_tax_classification_code varchar2(30);
1788: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

Line 1791: c_memo_line_id AR_MEMO_LINES.memo_line_id%type,

1787: -- l_tax_classification_code varchar2(30);
1788: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1789:
1790: CURSOR sel_memo_line_tax(
1791: c_memo_line_id AR_MEMO_LINES.memo_line_id%type,
1792: c_trx_date DATE,
1793: c_org_id NUMBER)
1794: IS
1795: SELECT m.tax_code

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

1792: c_trx_date DATE,
1793: c_org_id NUMBER)
1794: IS
1795: SELECT m.tax_code
1796: -- FROM fnd_lookups l, AR_MEMO_LINES M bug#4574838
1797: FROM zx_output_classifications_v l, AR_MEMO_LINES m
1798: WHERE m.memo_line_id = c_memo_line_id
1799: AND l.lookup_code = m.tax_code
1800: AND l.org_id IN (c_org_id, -99)

Line 1797: FROM zx_output_classifications_v l, AR_MEMO_LINES m

1793: c_org_id NUMBER)
1794: IS
1795: SELECT m.tax_code
1796: -- FROM fnd_lookups l, AR_MEMO_LINES M bug#4574838
1797: FROM zx_output_classifications_v l, AR_MEMO_LINES m
1798: WHERE m.memo_line_id = c_memo_line_id
1799: AND l.lookup_code = m.tax_code
1800: AND l.org_id IN (c_org_id, -99)
1801: AND l.enabled_flag = 'Y'