DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 6363: FROM so_price_list_lines A, JAI_CMN_CUS_ADDRESSES B

6359: /*
6360: CURSOR price_list_cur(p_customer_id IN Number,p_inventory_item_id IN Number,
6361: p_address_id IN Number DEFAULT 0,v_uom_code VARCHAR2, p_trx_date DATE) IS
6362: SELECT A.list_price, a.unit_code
6363: FROM so_price_list_lines A, JAI_CMN_CUS_ADDRESSES B
6364: WHERE A.price_list_id = B.price_list_id
6365: AND B.customer_id = p_customer_id
6366: AND B.address_id = p_address_id
6367: AND A.inventory_item_id = p_inventory_item_id

Line 8224: FROM JAI_CMN_CUS_ADDRESSES

8220: AND hzcas.cust_account_id = pn_party_id ;
8221:
8222: CURSOR cur_get_ser_type_customer(pn_cust_id NUMBER,pn_address_id NUMBER) IS
8223: SELECT service_type_code
8224: FROM JAI_CMN_CUS_ADDRESSES
8225: WHERE customer_id = pn_cust_id
8226: AND address_id = pn_address_id;
8227:
8228: CURSOR cur_get_ser_type_vendor(