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 2826: where price_list_id in (select price_list_id from JAI_CMN_CUS_ADDRESSES

2822: CURSOR price_list_cur(p_customer_id IN Number,p_inventory_item_id IN Number,
2823: p_address_id IN Number DEFAULT 0, v_uom_code VARCHAR2, p_trx_date DATE) IS
2824: select list_price, unit_code
2825: from so_price_list_lines
2826: where price_list_id in (select price_list_id from JAI_CMN_CUS_ADDRESSES
2827: where customer_id = p_customer_id and
2828: address_id = p_address_id) and
2829: inventory_item_id = p_inventory_item_id
2830: and unit_code = v_uom_code