DBA Data[Home] [Help]

APPS.XDP_ENGINE dependencies on DUAL

Line 2358: from dual

2354: is
2355:
2356: CURSOR c_CheckWIParam is
2357: select 'Y' yahoo
2358: from dual
2359: where exists(
2360: select 'x' from
2361: xdp_worklist_details
2362: where workitem_instance_id = p_wi_instance_id and

Line 2386: from dual

2382: lv_exists varchar2(1) := 'N';
2383:
2384: CURSOR c_CheckFAParam is
2385: select 'Y' yahoo
2386: from dual
2387: where exists(
2388: select 'x' from
2389: xdp_fa_details
2390: where fa_instance_id = p_fa_instance_id and

Line 2411: from dual

2407: is
2408:
2409: CURSOR c_CheckOrderParam is
2410: select 'Y' yahoo
2411: from dual
2412: where exists(
2413: select 'x'
2414: from xdp_order_parameters
2415: where order_id = p_order_id and

Line 2436: from dual

2432: p_parameter_name IN VARCHAR2) return VARCHAR2
2433: is
2434: CURSOR c_CheckLineParam is
2435: select 'Y' yahoo
2436: from dual
2437: where exists(
2438: select 'x'
2439: from XDP_ORDER_LINEITEM_DETS
2440: where line_item_id = p_line_item_id and