APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_CMN_RG_OTHERS

Line 1740: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

1736:
1737:
1738: -- start, Bgowrava for forward porting bug#5989740
1739:
1740: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1741: /* Cursor is responsible to get secondary and higher cess */
1742:
1743: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1744: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount

Line 1759: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

1755: );
1756: -- end, Bgowrava for forward porting bug#5989740
1757:
1758:
1759: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1760: lv_process_flag VARCHAR2(5);
1761: lv_process_message VARCHAR2(1996);
1762:
1763:

Line 3673: FROM JAI_CMN_RG_OTHERS

3669: WHERE register_id = p_register_id;
3670:
3671: CURSOR c_cess_details(p_register_id NUMBER) IS
3672: SELECT credit
3673: FROM JAI_CMN_RG_OTHERS
3674: WHERE source_register='RG23D'
3675: AND source_register_id=p_register_id
3676: AND tax_type='EXCISE_EDUCATION_CESS';
3677:

Line 3680: FROM JAI_CMN_RG_OTHERS

3676: AND tax_type='EXCISE_EDUCATION_CESS';
3677:
3678: CURSOR c_sh_cess_details(p_register_id NUMBER) IS
3679: SELECT credit
3680: FROM JAI_CMN_RG_OTHERS
3681: WHERE source_register='RG23D'
3682: AND source_register_id=p_register_id
3683: AND tax_type='EXCISE_SH_EDU_CESS';
3684: