DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 1524: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;

1520: pn_site_use_id NUMBER ) return boolean
1521:
1522: IS
1523: ln_address_id NUMBER;
1524: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
1525:
1526:
1527: CURSOR c_get_address is
1528: SELECT hzcas.cust_acct_site_id

Line 1537: FROM JAI_CMN_CUS_ADDRESSES

1533: AND hzcas.cust_account_id = pn_customer_id ;
1534:
1535: CURSOR c_regno (pn_address_id NUMBER) IS
1536: SELECT vat_Reg_no
1537: FROM JAI_CMN_CUS_ADDRESSES
1538: WHERE customer_id = pn_customer_id
1539: AND address_id = pn_address_id;
1540:
1541: BEGIN