DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 470: FROM JAI_CMN_CUS_ADDRESSES

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

Line 1588: FROM JAI_CMN_CUS_ADDRESSES

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