APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_AR_SUP_TAXES

Line 3034: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b

3030: v_customer_trx_line_id NUMBER;
3031:
3032: CURSOR SUPPLEMENT_TAX_LINES_CHECK IS
3033: SELECT 1
3034: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b
3035: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
3036: AND b.customer_trx_line_id = v_customer_Trx_line_id;
3037:
3038: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS

Line 3044: JAI_AR_SUP_TAXES E

3040: FROM JAI_AR_SUP_LINES A,
3041: JAI_AR_SUP_HDRS_ALL B,
3042: RA_CUSTOMER_TRX_ALL C,
3043: RA_CUST_TRX_TYPES_ALL D,
3044: JAI_AR_SUP_TAXES E
3045: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
3046: AND c.cust_trx_type_id = D.cust_trx_type_id
3047: AND c.trx_number = TO_CHAR(b.SUPPLEMENTARY_NUM)
3048: AND b.supp_inv_type = DECODE(D.TYPE,'INV','SI','CM','CR','DM','DB')

Line 3065: FROM JAI_AR_SUP_TAXES A,

3061: A.diff_amt,
3062: A.diff_amt FUNC_TAX_AMT,
3063: t.tax_type,
3064: t.stform_type
3065: FROM JAI_AR_SUP_TAXES A,
3066: JAI_AR_SUP_LINES b,
3067: ra_customer_trx_all C,
3068: ra_cust_trx_types_all D,
3069: JAI_CMN_TAXES_ALL t

Line 3089: FROM JAI_AR_SUP_TAXES A,

3085: SUM(A.diff_amt) DIFF_AMT,
3086: SUM(A.diff_amt) FUNC_TAX_AMT,
3087: t.tax_type,
3088: t.stform_type
3089: FROM JAI_AR_SUP_TAXES A,
3090: JAI_AR_SUP_LINES b,
3091: JAI_AR_SUP_HDRS_ALL c,
3092: ra_customer_trx_all D,
3093: ra_cust_trx_types_all e,