APPS.OE_HOLDS_PVT dependencies on OE_PAYMENT_TYPES_VL

Line 171: FROM oe_payment_types_vl

167: where ORGANIZATION_ID = p_hold_entity_id;
168:
169: CURSOR payment_type_value_cur IS
170: SELECT name
171: FROM oe_payment_types_vl
172: WHERE payment_type_code = p_hold_entity_id;
173:
174: CURSOR payment_term_value_cur IS
175: select name

Line 2485: FROM oe_payment_types_vl

2481: WHERE transaction_type_id = p_hold_source_rec.hold_entity_id;
2482: ELSIF p_hold_source_rec.hold_entity_code = 'P' THEN
2483: SELECT 'Valid Entity'
2484: INTO l_dummy
2485: FROM oe_payment_types_vl
2486: WHERE payment_type_code = p_hold_source_rec.hold_entity_id;
2487: ELSIF p_hold_source_rec.hold_entity_code = 'CD' THEN
2488: NULL;
2489: ELSIF p_hold_source_rec.hold_entity_code = 'SC' THEN

Line 2498: FROM oe_payment_types_vl

2494: AND lookup_type = 'SALES_CHANNEL';
2495: ELSIF p_hold_source_rec.hold_entity_code = 'PT' THEN
2496: SELECT 'Valid Entity'
2497: INTO l_dummy
2498: FROM oe_payment_types_vl
2499: WHERE payment_type_code = p_hold_source_rec.hold_entity_id;
2500: ELSIF p_hold_source_rec.hold_entity_code = 'SM' THEN
2501: SELECT 'Valid Entity'
2502: INTO l_dummy

Line 2627: FROM oe_payment_types_vl

2623: WHERE term_id = p_hold_source_rec.hold_entity_id2;
2624: ELSIF p_hold_source_rec.hold_entity_code2 = 'P' THEN
2625: SELECT 'Valid Entity'
2626: INTO l_dummy
2627: FROM oe_payment_types_vl
2628: WHERE payment_type_code = p_hold_source_rec.hold_entity_id2;
2629: ELSIF p_hold_source_rec.hold_entity_code2 = 'PL' THEN
2630: SELECT 'Valid Entity'
2631: INTO l_dummy