DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICE_LIST dependencies on QP_LIST_LINES

Line 26: from qp_list_lines

22:
23: cursor c_lines_edates_cur(p_list_header_id NUMBER, p_lh_end_date date) is
24: SELECT 'x' FROM dual WHERE EXISTS (
25: select 'x'
26: from qp_list_lines
27: where list_header_id = p_list_header_id
28: and NOT(end_date_active is null or end_date_active = FND_API.G_MISS_DATE)
29: AND p_lh_end_date 30:

Line 34: from qp_list_lines

30:
31: cursor c_lines_sdates_cur(p_list_header_id NUMBER, p_lh_start_date date) is
32: SELECT 'x' FROM dual WHERE EXISTS (
33: select 'x'
34: from qp_list_lines
35: where list_header_id = p_list_header_id
36: and NOT(start_date_active is null or start_date_active = FND_API.G_MISS_DATE)
37: AND p_lh_start_date>start_date_active);
38: