APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 2978: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;

2974: pn_site_use_id NUMBER ) return boolean
2975:
2976: IS
2977: ln_address_id NUMBER;
2978: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
2979:
2980:
2981: CURSOR c_get_address is
2982: SELECT hzcas.cust_acct_site_id

Line 2991: FROM JAI_CMN_CUS_ADDRESSES

2987: AND hzcas.cust_account_id = pn_customer_id ;
2988:
2989: CURSOR c_regno (pn_address_id NUMBER) IS
2990: SELECT vat_Reg_no
2991: FROM JAI_CMN_CUS_ADDRESSES
2992: WHERE customer_id = pn_customer_id
2993: AND address_id = pn_address_id;
2994:
2995: BEGIN