APPS.WSMPVCPD dependencies on DUAL

Line 27: ** FROM sys.dual

23:
24: /*
25: ** SELECT 'Y'
26: ** INTO x_result
27: ** FROM sys.dual
28: ** WHERE EXISTS (SELECT 1
29: ** FROM wsm_co_products bcp
30: ** WHERE bcp.bill_sequence_id = x_bill_sequence_id
31: ** AND sysdate >= bcp.effectivity_date

Line 113: FROM sys.dual

109:
110:
111: SELECT 1
112: INTO x_dummy
113: FROM sys.dual
114: WHERE NOT EXISTS (SELECT 1
115: FROM wsm_co_products bcp
116: WHERE bcp.co_product_group_id = x_co_product_group_id
117: AND bcp.co_product_id = x_co_product_id

Line 131: ** FROM sys.dual

127: -- commented out by abedajna on 10/12/00 for perf. tuning
128: /*
129: ** SELECT 1
130: ** INTO x_dummy
131: ** FROM sys.dual
132: ** WHERE NOT EXISTS (SELECT 1
133: ** FROM wsm_co_prod_comp_substitutes bcs
134: ** WHERE bcs.co_product_group_id = x_co_product_group_id
135: ** AND bcs.substitute_component_id = x_co_product_id);

Line 223: ** FROM sys.dual

219: -- commented out by abedajna on 10/12/00 for perf. tuning
220: /*
221: ** SELECT 1
222: ** INTO x_dummy
223: ** FROM sys.dual
224: ** WHERE EXISTS (SELECT 1
225: ** FROM wsm_co_products bcp
226: ** WHERE bcp.co_product_group_id = x_co_product_group_id
227: ** AND bcp.co_product_id = x_substitute_co_product_id);

Line 366: ** FROM sys.dual

362: -- commented out by abedajna on 10/12/00 for perf. tuning
363: /*
364: ** SELECT 1
365: ** INTO x_dummy
366: ** FROM sys.dual
367: ** WHERE EXISTS (SELECT 1
368: ** FROM wsm_co_products bcp
369: ** WHERE bcp.co_product_group_id = x_co_product_group_id
370: ** AND bcp.primary_flag = 'Y'

Line 512: FROM sys.dual

508: x_error_msg IN OUT NOCOPY VARCHAR2) IS
509:
510: CURSOR C (x_bill_seq_id NUMBER) IS
511: SELECT 1
512: FROM sys.dual
513: WHERE EXISTS (SELECT 1
514: FROM bom_inventory_components bic
515: WHERE bic.bill_sequence_id = x_bill_seq_id
516: AND ((x_disable_date is NULL)