APPS.MSC_X_NETTING_PKG dependencies on DUAL

Line 1333: from dual

1329: BEGIN
1330:
1331:
1332: select 1 into l_ret_flag
1333: from dual
1334: where exists ( select 1
1335: from msc_plan_org_status
1336: where plan_id = G_PLAN_ID
1337: and sr_instance_id = G_SR_INSTANCE_ID

Line 1759: from dual;

1755: l_user_id Number := fnd_global.user_id;
1756: BEGIN
1757: select msc_x_exception_details_s.nextval
1758: into l_ex_dtl_id
1759: from dual;
1760:
1761: insert into msc_x_exception_details ( exception_detail_id,
1762: exception_type,
1763: exception_type_name,

Line 1963: from dual

1959: BEGIN
1960:
1961:
1962: select 1 into l_ret_flag
1963: from dual
1964: where exists ( select 1
1965: from msc_item_exceptions ex
1966: where ex.plan_id = G_PLAN_ID
1967: and ex.company_id = p_company_id

Line 2045: FROM dual

2041:
2042: BEGIN
2043: SELECT 1
2044: INTO l_return_code
2045: FROM dual
2046: WHERE EXISTS (SELECT sd.order_number
2047: FROM msc_sup_dem_entries sd
2048: WHERE sd.plan_id = G_PLAN_ID
2049: AND sd.publisher_id = p_company_id

Line 2084: FROM dual

2080:
2081: BEGIN
2082: SELECT 1
2083: INTO l_return_code
2084: FROM dual
2085: WHERE EXISTS (SELECT sd.order_number
2086: FROM msc_sup_dem_entries sd
2087: WHERE sd.plan_id = G_PLAN_ID
2088: AND sd.publisher_id = p_company_id

Line 2123: FROM dual

2119:
2120: BEGIN
2121: SELECT 1
2122: INTO l_return_code
2123: FROM dual
2124: WHERE EXISTS (SELECT sd.order_number
2125: FROM msc_sup_dem_entries sd
2126: WHERE sd.plan_id = G_PLAN_ID
2127: AND sd.publisher_id = p_company_id

Line 2206: FROM dual

2202: BEGIN
2203:
2204: SELECT 1
2205: INTO l_ret_flag
2206: FROM dual
2207: WHERE EXISTS (SELECT 'x'
2208: FROM msc_x_exception_details
2209: WHERE plan_id = G_PLAN_ID
2210: AND company_id = p_company_id