APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_AR_SUP_HDRS_ALL

Line 2992: JAI_AR_SUP_HDRS_ALL B,

2988:
2989: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
2990: SELECT 1
2991: FROM JAI_AR_SUP_LINES A,
2992: JAI_AR_SUP_HDRS_ALL B,
2993: RA_CUSTOMER_TRX_ALL C,
2994: RA_CUST_TRX_TYPES_ALL D
2995: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
2996: AND c.cust_trx_type_id = D.cust_trx_type_id

Line 3011: JAI_AR_SUP_HDRS_ALL B,

3007: CURSOR JA_IN_RA_CUSTOMER_TRX_INFOCNSL IS
3008: SELECT A.organization_id,
3009: A.Location_id
3010: FROM JAI_AR_TRXS A,
3011: JAI_AR_SUP_HDRS_ALL B,
3012: RA_CUSTOMER_TRX_ALL C
3013: WHERE pr_new.customer_trx_id = c.customer_trx_id
3014: AND c.trx_number = TO_CHAR(B.SUPPLEMENTARY_NUM)
3015: AND B.customer_trx_id = A.customer_trx_id;

Line 3041: JAI_AR_SUP_HDRS_ALL B,

3037:
3038: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
3039: SELECT 1
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

Line 3091: JAI_AR_SUP_HDRS_ALL c,

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,
3094: JAI_CMN_TAXES_ALL t
3095: WHERE pr_new.customer_trx_id = D.customer_trx_id

Line 3124: FROM JAI_AR_SUP_HDRS_ALL

3120: WHERE customer_trx_id = pr_new.customer_trx_id;
3121:
3122: CURSOR GET_SITE(P_TRX_NUMBER VARCHAR2) IS
3123: SELECT customer_site
3124: FROM JAI_AR_SUP_HDRS_ALL
3125: WHERE TO_CHAR(supplementary_num) = p_trx_number;
3126:
3127: CURSOR SUPPLEMENT_LINES_INFO IS
3128: SELECT DISTINCT A.tax_category_id,

Line 3145: JAI_AR_SUP_HDRS_ALL b,

3141: SELECT SUM(NVL(A.excise_diff_amt,0))+SUM(NVL(A.other_diff_amt,0)) TAX_AMT,
3142: NVL(A.excise_diff_amt,0) excise_diff,
3143: A.new_assessable_value
3144: FROM JAI_AR_SUP_LINES A,
3145: JAI_AR_SUP_HDRS_ALL b,
3146: ra_customer_trx_all c,
3147: ra_cust_trx_types_all e
3148: WHERE pr_new.customer_trx_id = c.customer_trx_id
3149: AND c.trx_number = TO_CHAR( b.SUPPLEMENTARY_NUM)

Line 3163: JAI_AR_SUP_HDRS_ALL b,

3159:
3160: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
3161: SELECT A.tax_category_id
3162: FROM JAI_AR_SUP_LINES A,
3163: JAI_AR_SUP_HDRS_ALL b,
3164: ra_customer_trx_all c,
3165: ra_cust_trx_types_all D
3166: WHERE pr_new.customer_trx_id = c.customer_trx_id
3167: AND c.trx_number =TO_CHAR( b.SUPPLEMENTARY_NUM)