DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 529: FROM JAI_CMN_CUS_ADDRESSES

525: WHERE Customer_Trx_Line_Id = p_line_id;
526:
527: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
528: SELECT NVL( Exempt, 'N' )
529: FROM JAI_CMN_CUS_ADDRESSES
530: WHERE Customer_Id = p_customer_id
531: AND Address_Id = AddressId;
532:
533: CURSOR Fetch_OE_Address_Cur IS

Line 1679: FROM JAI_CMN_CUS_ADDRESSES

1675: WHERE transaction_temp_id = p_line_id;
1676:
1677: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
1678: SELECT NVL( Exempt, 'N' )
1679: FROM JAI_CMN_CUS_ADDRESSES
1680: WHERE Customer_Id = p_customer_id
1681: AND Address_Id = AddressId;
1682:
1683: CURSOR Fetch_OE_Address_Cur IS