466: WHERE Customer_Trx_Line_Id = p_line_id;
467:
468: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
469: SELECT NVL( Exempt, 'N' )
470: FROM JAI_CMN_CUS_ADDRESSES
471: WHERE Customer_Id = p_customer_id
472: AND Address_Id = AddressId;
473:
474: CURSOR Fetch_OE_Address_Cur IS
1584: WHERE transaction_temp_id = p_line_id;
1585:
1586: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
1587: SELECT NVL( Exempt, 'N' )
1588: FROM JAI_CMN_CUS_ADDRESSES
1589: WHERE Customer_Id = p_customer_id
1590: AND Address_Id = AddressId;
1591:
1592: CURSOR Fetch_OE_Address_Cur IS