APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PER_TIME_PERIODS

Line 311: FROM per_time_periods

307: -- cursor to compute budget start and end dates
308:
309: CURSOR budget_date_cur IS
310: SELECT MIN(start_date), MAX(end_date)
311: FROM per_time_periods
312: WHERE time_period_id IN
313: (
314: SELECT val.time_period_id
315: FROM per_budget_values val,

Line 1377: l_per_time_periods_rec per_time_periods%ROWTYPE;

1373: */
1374:
1375: l_proc varchar2(72) := g_package||'set_p_bpr_log_context';
1376: l_per_budget_values_rec per_budget_values%ROWTYPE;
1377: l_per_time_periods_rec per_time_periods%ROWTYPE;
1378:
1379: CURSOR csr_bpr_periods_rec IS
1380: SELECT *
1381: FROM per_budget_values

Line 1384: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS

1380: SELECT *
1381: FROM per_budget_values
1382: WHERE budget_value_id = p_budget_value_id ;
1383:
1384: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
1385: SELECT *
1386: FROM per_time_periods
1387: WHERE time_period_id = p_time_period_id ;
1388:

Line 1386: FROM per_time_periods

1382: WHERE budget_value_id = p_budget_value_id ;
1383:
1384: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
1385: SELECT *
1386: FROM per_time_periods
1387: WHERE time_period_id = p_time_period_id ;
1388:
1389:
1390: BEGIN

Line 1398: OPEN csr_per_time_periods(p_time_period_id => l_per_budget_values_rec.time_period_id);

1394: OPEN csr_bpr_periods_rec;
1395: FETCH csr_bpr_periods_rec INTO l_per_budget_values_rec;
1396: CLOSE csr_bpr_periods_rec;
1397:
1398: OPEN csr_per_time_periods(p_time_period_id => l_per_budget_values_rec.time_period_id);
1399: FETCH csr_per_time_periods INTO l_per_time_periods_rec;
1400: CLOSE csr_per_time_periods;
1401:
1402: -- set log context

Line 1399: FETCH csr_per_time_periods INTO l_per_time_periods_rec;

1395: FETCH csr_bpr_periods_rec INTO l_per_budget_values_rec;
1396: CLOSE csr_bpr_periods_rec;
1397:
1398: OPEN csr_per_time_periods(p_time_period_id => l_per_budget_values_rec.time_period_id);
1399: FETCH csr_per_time_periods INTO l_per_time_periods_rec;
1400: CLOSE csr_per_time_periods;
1401:
1402: -- set log context
1403:

Line 1400: CLOSE csr_per_time_periods;

1396: CLOSE csr_bpr_periods_rec;
1397:
1398: OPEN csr_per_time_periods(p_time_period_id => l_per_budget_values_rec.time_period_id);
1399: FETCH csr_per_time_periods INTO l_per_time_periods_rec;
1400: CLOSE csr_per_time_periods;
1401:
1402: -- set log context
1403:
1404: p_log_context := l_per_time_periods_rec.period_name;

Line 1404: p_log_context := l_per_time_periods_rec.period_name;

1400: CLOSE csr_per_time_periods;
1401:
1402: -- set log context
1403:
1404: p_log_context := l_per_time_periods_rec.period_name;
1405:
1406:
1407:
1408: hr_utility.set_location('Log Context : '||p_log_context, 101);