APPS.JAI_CMN_GST_INV_GEN_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 34: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;

30: pn_site_use_id NUMBER ) return boolean
31:
32: IS
33: ln_address_id NUMBER;
34: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
35:
36:
37: CURSOR c_get_address is
38: SELECT hzcas.cust_acct_site_id

Line 47: FROM JAI_CMN_CUS_ADDRESSES

43: AND hzcas.cust_account_id = pn_customer_id ;
44:
45: CURSOR c_regno (pn_address_id NUMBER) IS
46: SELECT vat_Reg_no
47: FROM JAI_CMN_CUS_ADDRESSES
48: WHERE customer_id = pn_customer_id
49: AND address_id = pn_address_id;
50:
51: BEGIN