DBA Data[Home] [Help]

APPS.OZF_FORECAST_UTIL_PVT dependencies on QP_LIST_HEADERS_B

Line 4191: FROM qp_list_headers_b qp,

4187:
4188: CURSOR offer_dates_csr(p_offer_code IN VARCHAR2) IS
4189: SELECT NVL(qp.start_date_active,trunc(SYSDATE)) start_date_active,
4190: NVL(qp.end_date_active, trunc(SYSDATE)) end_date_active
4191: FROM qp_list_headers_b qp,
4192: ozf_offers off
4193: WHERE off.offer_code = p_offer_code
4194: AND off.qp_list_header_id = qp.list_header_id ;
4195:

Line 4655: FROM qp_list_headers_b qp,

4651:
4652: CURSOR offer_dates_csr(p_offer_code IN VARCHAR2) IS
4653: SELECT NVL(qp.start_date_active,trunc(SYSDATE)) start_date_active,
4654: NVL(qp.end_date_active, trunc(SYSDATE)) end_date_active
4655: FROM qp_list_headers_b qp,
4656: ozf_offers off
4657: WHERE off.offer_code = p_offer_code
4658: AND off.qp_list_header_id = qp.list_header_id ;
4659: