DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on PER_TIME_PERIODS

Line 1272: from per_time_periods

1268: l_start_time_period_id number;
1269: l_end_time_period_id number;
1270: cursor c1 is
1271: select time_period_id,start_date
1272: from per_time_periods
1273: where period_set_name = l_calendar
1274: and start_date >= l_budget_start_date
1275: and start_date < l_budget_end_date
1276: order by start_date;

Line 1279: from per_time_periods

1275: and start_date < l_budget_end_date
1276: order by start_date;
1277: cursor c2 is
1278: select time_period_id,end_date
1279: from per_time_periods
1280: where period_set_name = l_calendar
1281: and end_date > l_budget_start_date
1282: and end_date <= l_budget_end_date
1283: and end_date > l_period_start_date