DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on QP_LIST_HEADERS_VL

Line 127: from qp_list_headers_vl

123: WHERE term_id = p_hold_entity_id;
124:
125: CURSOR price_list_value_cur IS
126: select name
127: from qp_list_headers_vl
128: WHERE list_header_id = p_hold_entity_id;
129:
130: CURSOR transaction_type_value_cur IS
131: select name

Line 2030: FROM qp_list_headers_vl

2026: WHERE PROJECT_ID = p_hold_source_rec.hold_entity_id;
2027: ELSIF p_hold_source_rec.hold_entity_code = 'PL' THEN
2028: SELECT 'Valid Entity'
2029: INTO l_dummy
2030: FROM qp_list_headers_vl
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

Line 2177: from qp_list_headers_vl

2173: WHERE payment_type_code = p_hold_source_rec.hold_entity_id2;
2174: ELSIF p_hold_source_rec.hold_entity_code2 = 'PL' THEN
2175: SELECT 'Valid Entity'
2176: INTO l_dummy
2177: from qp_list_headers_vl
2178: where list_header_id = p_hold_source_rec.hold_entity_id2;
2179: ELSIF p_hold_source_rec.hold_entity_code2 = 'PR' THEN
2180: SELECT 'Valid Entity'
2181: INTO l_dummy