APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 15: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;

11: ) return boolean
12:
13: IS
14: ln_address_id NUMBER;
15: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
16:
17: CURSOR c_get_address is
18: SELECT hzcas.cust_acct_site_id
19: FROM hz_cust_site_uses_all hzcsu ,

Line 27: FROM JAI_CMN_CUS_ADDRESSES

23: AND hzcas.cust_account_id = pn_customer_id ;
24:
25: CURSOR c_regno (pn_address_id NUMBER) IS
26: SELECT vat_Reg_no
27: FROM JAI_CMN_CUS_ADDRESSES
28: WHERE customer_id = pn_customer_id
29: AND address_id = pn_address_id;
30:
31:

Line 3353: where price_list_id in (select price_list_id from JAI_CMN_CUS_ADDRESSES

3349: CURSOR price_list_cur(p_customer_id IN Number,p_inventory_item_id IN Number,
3350: p_address_id IN Number DEFAULT 0, v_uom_code VARCHAR2, p_trx_date DATE) IS
3351: select list_price, unit_code
3352: from so_price_list_lines
3353: where price_list_id in (select price_list_id from JAI_CMN_CUS_ADDRESSES
3354: where customer_id = p_customer_id and
3355: address_id = p_address_id) and
3356: inventory_item_id = p_inventory_item_id
3357: and unit_code = v_uom_code