DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on PER_TIME_PERIODS

Line 1267: from per_time_periods

1263: l_start_time_period_id number;
1264: l_end_time_period_id number;
1265: cursor c1 is
1266: select time_period_id,start_date
1267: from per_time_periods
1268: where period_set_name = l_calendar
1269: and start_date >= l_budget_start_date
1270: and start_date < l_budget_end_date
1271: order by start_date;

Line 1274: from per_time_periods

1270: and start_date < l_budget_end_date
1271: order by start_date;
1272: cursor c2 is
1273: select time_period_id,end_date
1274: from per_time_periods
1275: where period_set_name = l_calendar
1276: and end_date > l_budget_start_date
1277: and end_date <= l_budget_end_date
1278: and end_date > l_period_start_date