APPS.OE_HEADER_PAYMENT_UTIL dependencies on OE_HOLD_SOURCES

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

838: ) IS
839:
840: CURSOR order_paytype_hold IS
841: Select OH.Order_hold_id,NVL(OH.hold_release_id,0)
842: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP
843: WHERE HS.hold_source_id=OH.hold_source_id
844: AND OH.header_id=OP.header_id
845: AND OP.payment_number=p_payment_number
846: AND ((HS.hold_entity_code= 'P' AND HS.hold_entity_id=OP.payment_type_code)