DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on QP_LIST_HEADERS_VL

Line 181: from qp_list_headers_vl

177: WHERE term_id = p_hold_entity_id;
178:
179: CURSOR price_list_value_cur IS
180: select name
181: from qp_list_headers_vl
182: WHERE list_header_id = p_hold_entity_id;
183:
184: CURSOR transaction_type_value_cur IS
185: select name

Line 2475: FROM qp_list_headers_vl

2471: WHERE PROJECT_ID = p_hold_source_rec.hold_entity_id;
2472: ELSIF p_hold_source_rec.hold_entity_code = 'PL' THEN
2473: SELECT 'Valid Entity'
2474: INTO l_dummy
2475: FROM qp_list_headers_vl
2476: WHERE list_header_id = p_hold_source_rec.hold_entity_id;
2477: ELSIF p_hold_source_rec.hold_entity_code = 'OT' THEN
2478: SELECT 'Valid Entity'
2479: INTO l_dummy

Line 2632: from qp_list_headers_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
2632: from qp_list_headers_vl
2633: where list_header_id = p_hold_source_rec.hold_entity_id2;
2634: ELSIF p_hold_source_rec.hold_entity_code2 = 'PR' THEN
2635: SELECT 'Valid Entity'
2636: INTO l_dummy