APPS.IBE_QUOTE_REL_OBJ_PVT dependencies on ASO_QUOTE_HEADERS

Line 34: FROM aso_quote_headers AQH1,

30: l_related_obj_rec.relationship_type_code := p_relationship_type_code;
31:
32: IF FND_API.To_Boolean(p_one_to_one) THEN
33: OPEN l_csr FOR SELECT AQH1.quote_header_id
34: FROM aso_quote_headers AQH1,
35: aso_quote_headers AQH2
36: WHERE AQH1.quote_number = AQH2.quote_number
37: AND AQH2.quote_header_id = p_quote_object_id
38: AND NOT EXISTS (SELECT 1

Line 35: aso_quote_headers AQH2

31:
32: IF FND_API.To_Boolean(p_one_to_one) THEN
33: OPEN l_csr FOR SELECT AQH1.quote_header_id
34: FROM aso_quote_headers AQH1,
35: aso_quote_headers AQH2
36: WHERE AQH1.quote_number = AQH2.quote_number
37: AND AQH2.quote_header_id = p_quote_object_id
38: AND NOT EXISTS (SELECT 1
39: FROM aso_quote_related_objects

Line 45: FROM aso_quote_headers AQH1,

41: AND quote_object_id = AQH1.quote_header_id
42: AND relationship_type_code = p_relationship_type_code);
43: ELSE
44: OPEN l_csr FOR SELECT AQH1.quote_header_id
45: FROM aso_quote_headers AQH1,
46: aso_quote_headers AQH2
47: WHERE AQH1.quote_number = AQH2.quote_number
48: AND AQH2.quote_header_id = p_quote_object_id;
49: END IF;

Line 46: aso_quote_headers AQH2

42: AND relationship_type_code = p_relationship_type_code);
43: ELSE
44: OPEN l_csr FOR SELECT AQH1.quote_header_id
45: FROM aso_quote_headers AQH1,
46: aso_quote_headers AQH2
47: WHERE AQH1.quote_number = AQH2.quote_number
48: AND AQH2.quote_header_id = p_quote_object_id;
49: END IF;
50: LOOP

Line 66: FROM aso_quote_headers

62: WHERE relationship_type_code = (SELECT relationship_type_code
63: FROM aso_quote_related_objects
64: WHERE related_object_id = p_related_object_id)
65: AND quote_object_id IN (SELECT quote_header_id
66: FROM aso_quote_headers
67: WHERE quote_number = (SELECT quote_number
68: FROM aso_quote_headers
69: WHERE quote_header_id = (SELECT quote_object_id
70: FROM aso_quote_related_objects

Line 68: FROM aso_quote_headers

64: WHERE related_object_id = p_related_object_id)
65: AND quote_object_id IN (SELECT quote_header_id
66: FROM aso_quote_headers
67: WHERE quote_number = (SELECT quote_number
68: FROM aso_quote_headers
69: WHERE quote_header_id = (SELECT quote_object_id
70: FROM aso_quote_related_objects
71: WHERE related_object_id = p_related_object_id)));
72: LOOP