APPS.JAI_AR_HCA_TRIGGER_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 19: From JAI_CMN_CUS_ADDRESSES

15: v_customer_id Number; -- := pr_old.customer_id; --Ramananda for File.Sql.35
16:
17: Cursor Cust_count IS
18: Select count(*)
19: From JAI_CMN_CUS_ADDRESSES
20: Where Customer_Id = v_customer_id;
21:
22: BEGIN
23: pv_return_code := jai_constants.successful ;

Line 54: Delete JAI_CMN_CUS_ADDRESSES

50:
51: If NVL(v_count,0) = 0 then
52: Return;
53: Else
54: Delete JAI_CMN_CUS_ADDRESSES
55: Where Customer_ID = v_customer_id;
56: End if;
57: /* Added an exception block by Ramananda for bug#4570303 */
58: EXCEPTION