APPS.PA_RATE_PVT_PKG dependencies on PA_REP_PERIOD_DATES_V

Line 1629: l_period_type pa_rep_period_dates_v.period_type%TYPE;

1625: 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
1626: IS
1627:
1628: l_completion_date pa_projects_all.completion_date%TYPE;
1629: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1630: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1631: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1632: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1633:

Line 1630: l_period_name pa_rep_period_dates_v.period_name%TYPE;

1626: IS
1627:
1628: l_completion_date pa_projects_all.completion_date%TYPE;
1629: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1630: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1631: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1632: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1633:
1634: /* Added for MCB2 */

Line 1631: l_start_date pa_rep_period_dates_v.start_date%TYPE;

1627:
1628: l_completion_date pa_projects_all.completion_date%TYPE;
1629: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1630: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1631: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1632: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1633:
1634: /* Added for MCB2 */
1635: l_converted_rev_amount pa_projects_all.project_value%TYPE;

Line 1632: l_end_date pa_rep_period_dates_v.end_date%TYPE;

1628: l_completion_date pa_projects_all.completion_date%TYPE;
1629: l_period_type pa_rep_period_dates_v.period_type%TYPE;
1630: l_period_name pa_rep_period_dates_v.period_name%TYPE;
1631: l_start_date pa_rep_period_dates_v.start_date%TYPE;
1632: l_end_date pa_rep_period_dates_v.end_date%TYPE;
1633:
1634: /* Added for MCB2 */
1635: l_converted_rev_amount pa_projects_all.project_value%TYPE;
1636: l_conversion_fail EXCEPTION;

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

1694:
1695: -- dbms_output.put_line(' 12 '||l_period_type);
1696:
1697: /* Added code for bug 2691192, this proc. will replace the call of
1698: pa_rep_period_dates_v.Because of performance issue tis view has been split
1699: in this new call of proc. */
1700:
1701: PA_RATE_PVT_PKG.get_rep_period_dates (
1702: p_period_type => l_period_type,

Line 1727: FROM pa_rep_period_dates_v

1723: /* Taking period name corresponds to the period type */
1724: /* Commneting out for bug 2691192
1725: SELECT period_name,start_date,end_date
1726: INTO l_period_name,l_start_date,l_end_date
1727: FROM pa_rep_period_dates_v
1728: WHERE period_type = l_period_type
1729: AND l_completion_date BETWEEN start_date AND end_date;
1730: */
1731:

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

3560: END calc_rate_amount;
3561:
3562:
3563:
3564: /* Added for performance bug 2691192, it replaces the use of view pa_rep_period_dates_v */
3565:
3566: -- This procedure will display information about period types such as the name of the period
3567: -- and the start and end dates.
3568: -- Input parameters