APPS.PA_RATE_PVT_PKG dependencies on PA_REP_PERIOD_DATES_V

Line 1560: l_period_type pa_rep_period_dates_v.period_type%TYPE;

1556: x_projfunc_revenue_tab OUT NOCOPY PA_RATE_PVT_PKG.ProjAmt_TabTyp /* This tabwill store aount in project functional currency */) --File.Sql.39 bug 4440895
1557: IS
1558:
1559: l_completion_date pa_projects_all.completion_date%TYPE;
1560: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1561: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1562: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1563: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1564:

Line 1561: l_period_name pa_rep_period_dates_v.period_name%TYPE;

1557: IS
1558:
1559: l_completion_date pa_projects_all.completion_date%TYPE;
1560: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1561: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1562: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1563: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1564:
1565: /* Added for MCB2 */

Line 1562: l_start_date pa_rep_period_dates_v.start_date%TYPE;

1558:
1559: l_completion_date pa_projects_all.completion_date%TYPE;
1560: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1561: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1562: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1563: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1564:
1565: /* Added for MCB2 */
1566: l_converted_rev_amount pa_projects_all.project_value%TYPE;

Line 1563: l_end_date pa_rep_period_dates_v.end_date%TYPE;

1559: l_completion_date pa_projects_all.completion_date%TYPE;
1560: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1561: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1562: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1563: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1564:
1565: /* Added for MCB2 */
1566: l_converted_rev_amount pa_projects_all.project_value%TYPE;
1567: l_conversion_fail EXCEPTION;

Line 1629: pa_rep_period_dates_v.Because of performance issue tis view has been split

1625:
1626: -- dbms_output.put_line(' 12 '||l_period_type);
1627:
1628: /* Added code for bug 2691192, this proc. will replace the call of
1629: pa_rep_period_dates_v.Because of performance issue tis view has been split
1630: in this new call of proc. */
1631:
1632: PA_RATE_PVT_PKG.get_rep_period_dates (
1633: p_period_type => l_period_type,

Line 1658: FROM pa_rep_period_dates_v

1654: /* Taking period name corresponds to the period type */
1655: /* Commneting out for bug 2691192
1656: SELECT period_name,start_date,end_date
1657: INTO l_period_name,l_start_date,l_end_date
1658: FROM pa_rep_period_dates_v
1659: WHERE period_type = l_period_type
1660: AND l_completion_date BETWEEN start_date AND end_date;
1661: */
1662:

Line 3426: /* Added for performance bug 2691192, it replaces the use of view pa_rep_period_dates_v */

3422: END calc_rate_amount;
3423:
3424:
3425:
3426: /* Added for performance bug 2691192, it replaces the use of view pa_rep_period_dates_v */
3427:
3428: -- This procedure will display information about period types such as the name of the period
3429: -- and the start and end dates.
3430: -- Input parameters