DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICE_LIST dependencies on DUAL

Line 24: SELECT 'x' FROM dual WHERE EXISTS (

20: l_unit_precision_type VARCHAR2(255):= '';
21: l_price_rounding VARCHAR2(50):= '';
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)

Line 32: SELECT 'x' FROM dual WHERE EXISTS (

28: and NOT(end_date_active is null or end_date_active = FND_API.G_MISS_DATE)
29: AND p_lh_end_date 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)