APPS.OE_VERIFY_PAYMENT_PUB dependencies on IBY_TANGIBLE

Line 2946: FROM IBY_TANGIBLE IT

2942: END IF;
2943:
2944: -- Create the query string
2945: l_sql_stmt := 'SELECT IT.TANGIBLEID, IT.AMOUNT
2946: FROM IBY_TANGIBLE IT
2947: WHERE IT.REFINFO = :ref_info
2948: AND EXISTS
2949: (SELECT ''Voice Auth Requested''
2950: FROM IBY_TRANS_ALL_V A

Line 4606: l_sql_stmt := 'UPDATE IBY_TANGIBLE IT

4602: oe_debug_pub.add( 'OEXPVPMB: SQL STMT TO UPDATE REFINFO WITH HEADER_ID' ) ;
4603: END IF;
4604: --
4605: /* Bug 6700106
4606: l_sql_stmt := 'UPDATE IBY_TANGIBLE IT
4607: SET IT.REFINFO = :ref_info1
4608: WHERE IT.TANGIBLEID IN
4609: (SELECT DISTINCT ITAV.TANGIBLEID
4610: FROM IBY_TRANS_ALL_V ITAV

Line 4631: /* UPDATE IBY_TANGIBLE IT

4627:
4628: -- Bug 6700106
4629:
4630: BEGIN
4631: /* UPDATE IBY_TANGIBLE IT
4632: SET IT.REFINFO = l_ref_info
4633: WHERE IT.TANGIBLEID IN
4634: (SELECT DISTINCT ITAV.TANGIBLEID
4635: FROM IBY_TRANS_ALL_V ITAV

Line 4644: UPDATE IBY_TANGIBLE IT

4640: AND (ITAV.REFINFO IS NULL
4641: OR ITAV.REFINFO <> l_ref_info));
4642: */
4643: --Bug 6770094
4644: UPDATE IBY_TANGIBLE IT
4645: SET IT.REFINFO = l_ref_info
4646: WHERE IT.TANGIBLEID IN
4647: (SELECT DISTINCT ITAV.TANGIBLEID
4648: FROM IBY_TRANS_ALL_V ITAV