APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_CMN_TAXES_ALL

Line 570: old_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/

566: p_mapping_id NUMBER;
567: a_mapping_id NUMBER;
568: new_tax_excise NUMBER := 0;
569: old_tax_excise NUMBER := 0;
570: old_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
571: new_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
572: old_tax_other NUMBER := 0;
573: new_tax_other NUMBER := 0;
574: old_tax_amount NUMBER := 0;

Line 571: new_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/

567: a_mapping_id NUMBER;
568: new_tax_excise NUMBER := 0;
569: old_tax_excise NUMBER := 0;
570: old_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
571: new_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
572: old_tax_other NUMBER := 0;
573: new_tax_other NUMBER := 0;
574: old_tax_amount NUMBER := 0;
575: new_tax_amount NUMBER := 0;

Line 1487: JAI_CMN_TAXES_ALL COD

1483: TEMP.PRECEDENCE_9,
1484: TEMP.PRECEDENCE_10,
1485: COD.ADHOC_FLAG
1486: FROM JAI_AR_TRX_TAX_CALC_T TEMP,
1487: JAI_CMN_TAXES_ALL COD
1488: WHERE LINK_TO_CUST_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID
1489: AND TEMP.TAX_ID = COD.TAX_ID;
1490:
1491: CURSOR GET_INV_TAX IS

Line 1579: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),

1575: TAX_LIST_CHANGE_INDICATOR := 'Y';
1576: v_statement_id := '60';
1577: UPDATE JAI_AR_TRX_TAX_CALC_T
1578: SET TAX_ID = CTAX.NEW_TYPE_ID,
1579: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),
1580: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)
1581: WHERE TAX_ID = CTAX.EXISTING_TYPE_ID;
1582: END IF;
1583:

Line 1580: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)

1576: v_statement_id := '60';
1577: UPDATE JAI_AR_TRX_TAX_CALC_T
1578: SET TAX_ID = CTAX.NEW_TYPE_ID,
1579: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),
1580: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)
1581: WHERE TAX_ID = CTAX.EXISTING_TYPE_ID;
1582: END IF;
1583:
1584: END LOOP;

Line 1837: SELECT TAX_TYPE INTO OLD_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = A.TAX_ID;

1833: v_statement_id := '84';
1834: IF A.TAX_LINE_NO = B.TAX_LINE_NO THEN
1835:
1836: v_statement_id := '85';
1837: SELECT TAX_TYPE INTO OLD_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = A.TAX_ID;
1838:
1839: v_statement_id := '86';
1840: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;
1841:

Line 1840: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;

1836: v_statement_id := '85';
1837: SELECT TAX_TYPE INTO OLD_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = A.TAX_ID;
1838:
1839: v_statement_id := '86';
1840: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;
1841:
1842: IF UPPER(OLD_TAX_TYPE) LIKE '%EXCISE%' THEN /*Added UPPER to include all excise type of taxes by mmurtuza for bug 16580917*/
1843: v_statement_id := '87';
1844: UPDATE JAI_AR_SUP_LINES

Line 2709: JAI_CMN_TAXES_ALL d

2705: ) tax_type_val,
2706: d.inclusive_tax_flag -- Added by Jia Li for Tax Inclusive Computations on 2007/12/07
2707: FROM
2708: JAI_AR_TRX_TAX_CALC_T c,
2709: JAI_CMN_TAXES_ALL d
2710: WHERE
2711: c.link_to_cust_trx_line_id = p_line_id AND
2712: c.tax_id = d.tax_id
2713: ORDER BY