APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on QP_LIST_HEADERS_B

Line 107: FROM qp_list_headers_b

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

Line 112: FROM qp_list_headers_b

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

Line 724: FROM qp_list_headers_b q, ozf_offers o

720: WHERE qp_list_header_id = l_list_header_id;
721:
722: CURSOR c_get_start_date IS
723: SELECT q.start_date_active, o.start_date
724: FROM qp_list_headers_b q, ozf_offers o
725: WHERE o.qp_list_header_id = q.list_header_id
726: AND q.list_header_id = p_offers_rec.qp_list_header_id;
727:
728: l_api_name CONSTANT VARCHAR2(30) := 'Update_Offers';

Line 1253: FROM qp_list_headers_b

1249: IS
1250:
1251: CURSOR C_OFFER_END_DATE IS
1252: SELECT end_date_active
1253: FROM qp_list_headers_b
1254: WHERE list_header_id = p_offers_rec.qp_list_header_id;
1255:
1256: l_offer_end_date DATE;
1257:

Line 1446: 'qp_list_headers_b'

1442:
1443: --- checking the qp_list_header_id
1444: IF p_offers_rec.qp_list_header_id <> FND_API.G_MISS_NUM THEN
1445: IF OZF_Utility_PVT.check_fk_exists(
1446: 'qp_list_headers_b'
1447: ,'list_header_id '
1448: ,p_offers_rec.qp_list_header_id) = FND_API.g_false
1449: THEN
1450: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');