DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 4983: FROM so_price_list_lines A, JAI_CMN_CUS_ADDRESSES B

4979: /*
4980: CURSOR price_list_cur(p_customer_id IN Number,p_inventory_item_id IN Number,
4981: p_address_id IN Number DEFAULT 0,v_uom_code VARCHAR2, p_trx_date DATE) IS
4982: SELECT A.list_price, a.unit_code
4983: FROM so_price_list_lines A, JAI_CMN_CUS_ADDRESSES B
4984: WHERE A.price_list_id = B.price_list_id
4985: AND B.customer_id = p_customer_id
4986: AND B.address_id = p_address_id
4987: AND A.inventory_item_id = p_inventory_item_id

Line 6727: FROM JAI_CMN_CUS_ADDRESSES

6723: AND hzcas.cust_account_id = pn_party_id ;
6724:
6725: CURSOR cur_get_ser_type_customer(pn_cust_id NUMBER,pn_address_id NUMBER) IS
6726: SELECT service_type_code
6727: FROM JAI_CMN_CUS_ADDRESSES
6728: WHERE customer_id = pn_cust_id
6729: AND address_id = pn_address_id;
6730:
6731: CURSOR cur_get_ser_type_vendor(