DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_REVISION dependencies on DUAL

Line 368: FROM dual

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

Line 429: FROM dual

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