DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_REVISION dependencies on DUAL

Line 366: FROM dual

362: --
363: BEGIN
364: SELECT 1
365: INTO l_dummy
366: FROM dual
367: WHERE not exists
368: (SELECT 1
369: FROM mtl_rtg_item_revisions
370: WHERE organization_id = p_rtg_rev_Unexp_Rec.Organization_Id

Line 427: FROM dual

423: THEN
424: BEGIN
425: SELECT 1
426: INTO l_dummy
427: FROM dual
428: WHERE p_rtg_revision_rec.start_effective_date >
429: (SELECT nvl(max(effectivity_date),
430: p_rtg_revision_rec.start_effective_Date-1)
431: FROM mtl_rtg_item_revisions