APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_CMN_RG_OTHERS

Line 783: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

779: WHERE delivery_id = cp_delivery_id
780: )
781: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
782:
783: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
784:
785: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
786: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
787: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

Line 799: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

795: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_sh_exc_edu_cess),
796: upper(jai_constants.tax_type_sh_cvd_edu_cess)
797: );
798:
799: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
800: lv_process_flag VARCHAR2(5);
801: lv_process_message VARCHAR2(1996);
802:
803: ln_vat_cnt NUMBER DEFAULT 0 ;

Line 2044: FROM JAI_CMN_RG_OTHERS

2040: WHERE register_id = p_register_id;
2041:
2042: CURSOR c_cess_details(p_register_id NUMBER) IS
2043: SELECT credit
2044: FROM JAI_CMN_RG_OTHERS
2045: WHERE source_register = 'RG23D'
2046: AND source_register_id = p_register_id
2047: AND tax_type = 'EXCISE_EDUCATION_CESS';
2048:

Line 2051: FROM JAI_CMN_RG_OTHERS

2047: AND tax_type = 'EXCISE_EDUCATION_CESS';
2048:
2049: CURSOR c_sh_cess_details(p_register_id NUMBER) IS
2050: SELECT credit
2051: FROM JAI_CMN_RG_OTHERS
2052: WHERE source_register = 'RG23D'
2053: AND source_register_id = p_register_id
2054: AND tax_type = 'EXCISE_SH_EDU_CESS';
2055: