eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_PERIODS_ALL

Line 574: /* Commented for bug 3434019. Pa_periods_all is used to fetch data.

570: IF p_start_date IS NOT NULL AND p_end_date IS NOT NULL THEN
571:
572: BEGIN
573:
574: /* Commented for bug 3434019. Pa_periods_all is used to fetch data.
575: SELECT glper.start_date,
576: glper.end_date,
577: glper.period_name
578: BULK COLLECT INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab

Line 602: FROM pa_periods_all pp

598: pp.end_date,
599: pp.period_name
600: BULK COLLECT
601: INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab
602: FROM pa_periods_all pp
603: WHERE pp.org_id = p_org_id
604: --Bug 4276273 - trunc added
605: AND ( (trunc(p_start_date) BETWEEN pp.start_date AND
606: pp.end_date)

Line 620: /* Commented for bug 3434019. Instead pa_periods_all is used to fetch data.

616:
617:
618: BEGIN
619:
620: /* Commented for bug 3434019. Instead pa_periods_all is used to fetch data.
621: SELECT glper.start_date,
622: glper.end_date,
623: glper.period_name
624: BULK COLLECT

Line 646: FROM pa_periods_all pp

642: pp.end_date,
643: pp.period_name
644: BULK COLLECT
645: INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab
646: FROM pa_periods_all pp
647: WHERE pp.org_id = p_org_id
648: --Bug 4276273 - trunc added
649: AND trunc(p_start_date) BETWEEN pp.start_date and pp.end_date
650: order by pp.end_date;