APPS.IBE_REPORTING_PVT dependencies on DUAL

Line 583: From Dual;

579: ElsIf pFrequency = 'WEEK' Then
580:
581: Select trunc(NEXT_DAY(pDate-7,l_StartDay))
582: into pStartDate
583: From Dual;
584:
585: -- pStartDate := trunc(NEXT_DAY(pDate-7,l_StartDay));
586: pEndDate := pDate;
587: ElsIf pFrequency = 'ROLLING13WK' Then

Line 591: From Dual;

587: ElsIf pFrequency = 'ROLLING13WK' Then
588:
589: Select trunc(NEXT_DAY(pDate-7*14,l_StartDay))
590: into pStartDate
591: From Dual;
592:
593: pEndDate := pDate;
594:
595: ElsIf pFrequency = 'MONTH' Then

Line 1650: select user into l_username from dual;

1646: makeLogEntry(pMViewName,'COMPLETE',0,x_BeginDate,x_EndDate,Sysdate,null,null,l_mvLogID);
1647:
1648: Begin
1649:
1650: select user into l_username from dual;
1651:
1652: updateLog(pMViewName,'COMPLETE',1,2,null,null);
1653: updateLog(pMViewName,'COMPLETE',-1,2,null,null);
1654:

Line 1809: from dual ;

1805: return_amount(p_inventory_item_id,p_organization_id,p_order_header_id),
1806: Sum((decode(p_line_category_code,'RETURN',-1,1)* nvl(p_ordered_Quantity,0))*
1807: (nvl(p_Unit_Selling_Price,0)*nvl(p_conversion_rate,1))))
1808: into l_return_amount
1809: from dual ;
1810:
1811:
1812: return l_return_amount;
1813: