APPS.FWK_TBX_SEED dependencies on DUAL

Line 22: from dual

18: p_display_name,
19: p_description,
20: 'US',
21: 'US'
22: from dual
23: where not exists
24: (select null
25: from fwk_tbx_lookup_types_tl t
26: where t.lookup_type = p_lookup_type

Line 54: from dual

50: select p_lookup_type,
51: p_lookup_code,
52: p_start_date,
53: p_end_date
54: from dual
55: where not exists (select null
56: from fwk_tbx_lookup_codes_b
57: where lookup_type = p_lookup_type
58: and lookup_code = p_lookup_code);

Line 74: from dual

70: p_meaning,
71: p_description,
72: 'US',
73: 'US'
74: from dual
75: where not exists
76: (select null
77: from fwk_tbx_lookup_codes_tl t
78: where t.lookup_type = p_lookup_type

Line 229: from dual

225: sysdate,
226: 0,
227: sysdate,
228: 0
229: from dual
230: where not exists (select null
231: from fwk_tbx_employees
232: where employee_id = p_employee_id);
233:

Line 294: from dual

290: sysdate,
291: 0,
292: sysdate,
293: 0
294: from dual
295: where not exists (select null
296: from fwk_tbx_addresses
297: where address_id = p_address_id);
298:

Line 329: from dual

325: sysdate,
326: 0,
327: sysdate,
328: 0
329: from dual
330: where not exists (select null
331: from fwk_tbx_suppliers
332: where supplier_id = p_supplier_id);
333:

Line 376: from dual

372: sysdate,
373: 0,
374: sysdate,
375: 0
376: from dual
377: where not exists (select null
378: from fwk_tbx_supplier_sites
379: where supplier_site_id = p_supplier_site_id);
380:

Line 432: from dual

428: sysdate,
429: 0,
430: p_fwkitem_id,
431: p_fwkitem_structure_id
432: from dual
433: where not exists (select null
434: from fwk_tbx_items
435: where item_id = p_item_id);
436:

Line 492: from dual

488: sysdate,
489: 0,
490: sysdate,
491: 0
492: from dual
493: where not exists (select null
494: from fwk_tbx_po_headers
495: where header_id = p_header_id);
496:

Line 538: from dual

534: sysdate,
535: 0,
536: sysdate,
537: 0
538: from dual
539: where not exists (select null
540: from fwk_tbx_po_lines
541: where line_id = p_line_id);
542:

Line 585: from dual

581: sysdate,
582: 0,
583: sysdate,
584: 0
585: from dual
586: where not exists (select null
587: from fwk_tbx_po_shipments
588: where shipment_id = p_shipment_id);
589:

Line 654: from dual

650: 0,
651: 0,
652: sysdate,
653: 0
654: from dual
655: where not exists (select null
656: from fwk_tbx_item_ccids
657: where fwkitem_id = p_fwkitem_id);
658:

Line 697: FROM DUAL

693: sysdate,
694: 0,
695: sysdate,
696: 0
697: FROM DUAL
698: WHERE not exists (SELECT null
699: FROM FWK_TBX_PROJECT_HEADERS
700: WHERE PROJECT_ID = p_project_id);
701:

Line 742: FROM DUAL

738: sysdate,
739: 0,
740: sysdate,
741: 0
742: FROM DUAL
743: WHERE not exists (SELECT null
744: FROM FWK_TBX_PROJECT_DETAILS
745: WHERE TASK_ID = p_task_id);
746: