APPS.INV_TRANSACTION_FLOW_PUB dependencies on DUAL

Line 1057: INTO l_header_id FROM dual;

1053: fnd_msg_pub.initialize;
1054: END IF;
1055:
1056: SELECT mtl_transaction_flow_headers_s.NEXTVAL
1057: INTO l_header_id FROM dual;
1058:
1059: l_line_number := 0;
1060:
1061: SAVEPOINT CREATE_TRANSACTION_FLOW;

Line 2322: SELECT 1 INTO nDummy FROM DUAL

2318: DECLARE
2319: nDummy NUMBER;
2320: BEGIN
2321:
2322: SELECT 1 INTO nDummy FROM DUAL
2323: WHERE EXISTS (SELECT 1 FROM MTL_TRANSACTION_FLOW_HEADERS
2324: WHERE START_ORG_ID = p_ship_organization_id
2325: AND END_ORG_ID = p_ship_organization_id
2326: AND (NEW_ACCOUNTING_FLAG = 'Y' OR FLOW_TYPE <> 1));

Line 2368: SELECT 'Y' INTO l_valid FROM dual

2364: NULL;
2365: ELSE
2366: l_valid := 'N';
2367: BEGIN
2368: SELECT 'Y' INTO l_valid FROM dual
2369: WHERE
2370: exists(SELECT CUST_ACCOUNT_ID
2371: FROM HZ_CUST_ACCOUNTS
2372: WHERE CUST_ACCOUNT_ID = p_customer_id);

Line 2396: SELECT 'Y' INTO l_valid FROM dual

2392: BEGIN
2393: /* Modified query below : RA to HZ conversions
2394: Replaced occurances of RA views with HZ tables*/
2395: /*
2396: SELECT 'Y' INTO l_valid FROM dual
2397: WHERE
2398: exists
2399: (select rsu.address_id
2400: from ra_addresses_all ra , ra_site_uses_all rsu

Line 2411: FROM DUAL

2407: AND rsu.site_use_id = Decode(p_customer_site_id,g_miss_num,rsu.site_use_id,p_customer_site_id));
2408: */
2409:
2410: SELECT 'Y' INTO l_valid
2411: FROM DUAL
2412: WHERE EXISTS(
2413: SELECT rsu.cust_acct_site_id
2414: FROM (SELECT loc_id address_id
2415: , acct_site.status

Line 2457: SELECT 'Y' INTO l_valid FROM dual

2453: BEGIN
2454: /* Modified query below : RA to HZ conversions
2455: Replaced occurances of RA views with HZ tables*/
2456: /*
2457: SELECT 'Y' INTO l_valid FROM dual
2458: WHERE
2459: exists
2460: (select rsu.site_use_id
2461: from ra_addresses_all ra , ra_site_uses_all rsu

Line 2472: FROM DUAL

2468: AND rsu.site_use_id = p_customer_site_id);
2469: */
2470:
2471: SELECT 'Y' INTO l_valid
2472: FROM DUAL
2473: WHERE EXISTS(
2474: SELECT rsu.site_use_id
2475: FROM (SELECT loc_id address_id
2476: , acct_site.status

Line 2515: SELECT 'Y' INTO l_valid FROM dual

2511:
2512: ELSE
2513: l_valid := 'N';
2514: BEGIN
2515: SELECT 'Y' INTO l_valid FROM dual
2516: WHERE
2517: exists
2518: (select cust_trx_type_id
2519: from ra_cust_trx_types_all

Line 2546: SELECT 'Y' INTO l_valid FROM dual

2542:
2543: ELSE
2544: l_valid := 'N';
2545: BEGIN
2546: SELECT 'Y' INTO l_valid FROM dual
2547: WHERE
2548: exists
2549: (select pov.vendor_id from
2550: po_vendors pov,

Line 2579: SELECT 'Y' INTO l_valid FROM dual

2575:
2576: ELSE
2577: l_valid := 'N';
2578: BEGIN
2579: SELECT 'Y' INTO l_valid FROM dual
2580: WHERE
2581: exists
2582: (select vendor_site_id
2583: from po_vendor_sites_all