APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on QP_LIST_HEADERS_B

Line 105: FROM qp_list_headers_b

101: l_access_id NUMBER;
102:
103: CURSOR c_get_start_end_date(l_list_header_id NUMBER) IS
104: SELECT start_date_active, end_date_active
105: FROM qp_list_headers_b
106: WHERE list_header_id = l_list_header_id;
107:
108: CURSOR c_get_start_date IS
109: SELECT start_date_active

Line 110: FROM qp_list_headers_b

106: WHERE list_header_id = l_list_header_id;
107:
108: CURSOR c_get_start_date IS
109: SELECT start_date_active
110: FROM qp_list_headers_b
111: WHERE list_header_id = p_offers_rec.qp_list_header_id;
112:
113: l_start_date DATE;
114: l_end_date DATE;

Line 715: FROM qp_list_headers_b q, ozf_offers o

711: WHERE qp_list_header_id = l_list_header_id;
712:
713: CURSOR c_get_start_date IS
714: SELECT q.start_date_active, o.start_date
715: FROM qp_list_headers_b q, ozf_offers o
716: WHERE o.qp_list_header_id = q.list_header_id
717: AND q.list_header_id = p_offers_rec.qp_list_header_id;
718:
719: l_api_name CONSTANT VARCHAR2(30) := 'Update_Offers';

Line 1241: FROM qp_list_headers_b

1237: IS
1238:
1239: CURSOR C_OFFER_END_DATE IS
1240: SELECT end_date_active
1241: FROM qp_list_headers_b
1242: WHERE list_header_id = p_offers_rec.qp_list_header_id;
1243:
1244: l_offer_end_date DATE;
1245:

Line 1434: 'qp_list_headers_b'

1430:
1431: --- checking the qp_list_header_id
1432: IF p_offers_rec.qp_list_header_id <> FND_API.G_MISS_NUM THEN
1433: IF OZF_Utility_PVT.check_fk_exists(
1434: 'qp_list_headers_b'
1435: ,'list_header_id '
1436: ,p_offers_rec.qp_list_header_id) = FND_API.g_false
1437: THEN
1438: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');