APPS.OE_VERIFY_PAYMENT_PUB dependencies on IBY_TANGIBLE

Line 3019: FROM IBY_TANGIBLE IT

3015: END IF;
3016:
3017: -- Create the query string
3018: l_sql_stmt := 'SELECT IT.TANGIBLEID, IT.AMOUNT
3019: FROM IBY_TANGIBLE IT
3020: WHERE IT.REFINFO = :ref_info
3021: AND EXISTS
3022: (SELECT ''Voice Auth Requested''
3023: FROM IBY_TRANS_ALL_V A

Line 4679: l_sql_stmt := 'UPDATE IBY_TANGIBLE IT

4675: oe_debug_pub.add( 'OEXPVPMB: SQL STMT TO UPDATE REFINFO WITH HEADER_ID' ) ;
4676: END IF;
4677: --
4678: /* Bug 6700106
4679: l_sql_stmt := 'UPDATE IBY_TANGIBLE IT
4680: SET IT.REFINFO = :ref_info1
4681: WHERE IT.TANGIBLEID IN
4682: (SELECT DISTINCT ITAV.TANGIBLEID
4683: FROM IBY_TRANS_ALL_V ITAV

Line 4704: /* UPDATE IBY_TANGIBLE IT

4700:
4701: -- Bug 6700106
4702:
4703: BEGIN
4704: /* UPDATE IBY_TANGIBLE IT
4705: SET IT.REFINFO = l_ref_info
4706: WHERE IT.TANGIBLEID IN
4707: (SELECT DISTINCT ITAV.TANGIBLEID
4708: FROM IBY_TRANS_ALL_V ITAV

Line 4717: UPDATE IBY_TANGIBLE IT

4713: AND (ITAV.REFINFO IS NULL
4714: OR ITAV.REFINFO <> l_ref_info));
4715: */
4716: --Bug 6770094
4717: UPDATE IBY_TANGIBLE IT
4718: SET IT.REFINFO = l_ref_info
4719: WHERE IT.TANGIBLEID IN
4720: (SELECT DISTINCT ITAV.TANGIBLEID
4721: FROM IBY_TRANS_ALL_V ITAV