APPS.JAI_AR_TRX_LINES_PKG dependencies on JAI_CMN_TAXES_ALL

Line 119: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

115: 'TDS',
116: 2,
117: 0) tax_type_val,
118: b.tax_type
119: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
120: WHERE a.customer_trx_line_id = v_prev_customer_trx_line_id
121: AND a.tax_id = b.tax_id;
122:
123: CURSOR header_info_cur IS

Line 483: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,

479: FROM JAI_RGM_DEFINITIONS
480: WHERE REGIME_CODE = CP_REGIME_CODE;
481:
482: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,
483: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
484: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
485: SELECT COUNT(1)
486: FROM JAI_CMN_TAX_CTG_LINES CATL,
487: JAI_CMN_TAXES_ALL CODES,

Line 487: JAI_CMN_TAXES_ALL CODES,

483: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
484: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
485: SELECT COUNT(1)
486: FROM JAI_CMN_TAX_CTG_LINES CATL,
487: JAI_CMN_TAXES_ALL CODES,
488: JAI_REGIME_TAX_TYPES_V JRTTV
489: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
490: AND CATL.TAX_ID = CODES.TAX_ID
491: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE

Line 537: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

533: WHERE A.site_use_id = NVL(p_ship_to_site_use_id, 0);
534:
535: CURSOR excise_cal_cur IS
536: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
537: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
538: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
539: AND A.tax_id = B.tax_id
540: ORDER BY 1;
541:

Line 1133: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

1129: WHERE customer_trx_id = v_header_id;
1130:
1131: CURSOR excise_cal_cur IS
1132: select A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
1133: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
1134: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
1135: and A.tax_id = B.tax_id
1136: order by 1;
1137:

Line 1481: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

1477: WHERE A.site_use_id = p_ship_to_site_use_id;
1478:
1479: CURSOR excise_cal_cur IS
1480: select A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
1481: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
1482: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
1483: and A.tax_id = B.tax_id
1484: order by 1;
1485:

Line 1790: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

1786: v_once_completed_flag Varchar2(1);
1787:
1788: CURSOR excise_cal_cur IS
1789: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
1790: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
1791: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
1792: and A.tax_id = B.tax_id
1793: order by 1;
1794: