DBA Data[Home] [Help]

APPS.OE_LINE_PAYMENT_UTIL dependencies on OE_HOLD_SOURCES

Line 857: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP

853: ) IS
854:
855: CURSOR line_paytype_hold IS
856: Select OH.Order_hold_id,NVL(OH.hold_release_id,0)
857: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP
858: WHERE HS.hold_source_id=OH.hold_source_id
859: AND OH.header_id=OP.header_id
860: AND OH.line_id=OP.line_id
861: AND OP.payment_number=p_payment_number