DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on PER_TIME_PERIODS

Line 1593: from pqh_budget_periods bpr, per_time_periods tp_s,

1589:
1590: --get the budget_unit_values
1591: cursor c3(p_budget_detail_id number) is
1592: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
1593: from pqh_budget_periods bpr, per_time_periods tp_s,
1594: per_time_periods tp_e
1595: where bpr.budget_detail_id = p_budget_detail_id
1596: and tp_s.time_period_id = bpr.start_time_period_id
1597: and tp_e.time_period_id = bpr.end_time_period_id

Line 1594: per_time_periods tp_e

1590: --get the budget_unit_values
1591: cursor c3(p_budget_detail_id number) is
1592: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
1593: from pqh_budget_periods bpr, per_time_periods tp_s,
1594: per_time_periods tp_e
1595: where bpr.budget_detail_id = p_budget_detail_id
1596: and tp_s.time_period_id = bpr.start_time_period_id
1597: and tp_e.time_period_id = bpr.end_time_period_id
1598: and tp_s.period_set_name = l_calendar