APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 25: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;

21: ) return boolean
22:
23: IS
24: ln_address_id NUMBER;
25: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
26:
27: CURSOR c_get_address is
28: SELECT hzcas.cust_acct_site_id
29: FROM hz_cust_site_uses_all hzcsu ,

Line 37: FROM JAI_CMN_CUS_ADDRESSES

33: AND hzcas.cust_account_id = pn_customer_id ;
34:
35: CURSOR c_regno (pn_address_id NUMBER) IS
36: SELECT vat_Reg_no
37: FROM JAI_CMN_CUS_ADDRESSES
38: WHERE customer_id = pn_customer_id
39: AND address_id = pn_address_id;
40:
41: