APPS.OE_HOLDS_PVT dependencies on OE_TRANSACTION_TYPES

Line 132: from oe_transaction_types

128: WHERE list_header_id = p_hold_entity_id;
129:
130: CURSOR transaction_type_value_cur IS
131: select name
132: from oe_transaction_types
133: WHERE transaction_type_id = p_hold_entity_id;
134:
135: CURSOR source_type_value_cur IS
136: select meaning

Line 2035: FROM oe_transaction_types

2031: WHERE list_header_id = p_hold_source_rec.hold_entity_id;
2032: ELSIF p_hold_source_rec.hold_entity_code = 'OT' THEN
2033: SELECT 'Valid Entity'
2034: INTO l_dummy
2035: FROM oe_transaction_types
2036: WHERE transaction_type_id = p_hold_source_rec.hold_entity_id;
2037: ELSIF p_hold_source_rec.hold_entity_code = 'P' THEN
2038: SELECT 'Valid Entity'
2039: INTO l_dummy

Line 2157: FROM oe_transaction_types

2153: AND site_use_code = 'DELIVER_TO';
2154: ELSIF p_hold_source_rec.hold_entity_code2 in ('LT','OT') THEN
2155: SELECT 'Valid Entity'
2156: INTO l_dummy
2157: FROM oe_transaction_types
2158: WHERE transaction_type_id = p_hold_source_rec.hold_entity_id2;
2159: ELSIF p_hold_source_rec.hold_entity_code2 = 'OI' THEN
2160: SELECT 'Valid Entity'
2161: INTO l_dummy