DBA Data[Home] [Help]

APPS.OZF_COPY_OFFER_PVT dependencies on QP_LIST_HEADERS_TL

Line 1637: FROM qp_list_headers_tl -- Bug 13360969 changed table name

1633: CURSOR c_count_qp_code(l_code VARCHAR2) IS
1634: SELECT 1
1635: FROM DUAL
1636: WHERE EXISTS (SELECT 1
1637: FROM qp_list_headers_tl -- Bug 13360969 changed table name
1638: WHERE name = l_code);
1639:
1640: CURSOR c_get_list_header_id(l_name VARCHAR2) IS
1641: SELECT list_header_id

Line 1642: FROM qp_list_headers_tl -- Bug 13360969 changed table name to fetch list_header_id, fetching of list_header_id was not consisitent with qp_list_headers

1638: WHERE name = l_code);
1639:
1640: CURSOR c_get_list_header_id(l_name VARCHAR2) IS
1641: SELECT list_header_id
1642: FROM qp_list_headers_tl -- Bug 13360969 changed table name to fetch list_header_id, fetching of list_header_id was not consisitent with qp_list_headers
1643: WHERE name = l_name;
1644:
1645: CURSOR c_new_offer_id IS
1646: SELECT ozf_offers_s.NEXTVAL