APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PER_BUDGET_VERSIONS

Line 45: FROM per_budget_versions

41: AND NVL(budget_type_code,'X') <> 'OTA_BUDGET' ;
42:
43: CURSOR per_budget_ver_cur (p_budget_id IN per_budgets.budget_id%TYPE) IS
44: SELECT *
45: FROM per_budget_versions
46: WHERE budget_id = p_budget_id;
47:
48: CURSOR per_budget_elmnt_cur (p_budget_version_id IN per_budget_versions.budget_version_id%TYPE) IS
49: SELECT *

Line 48: CURSOR per_budget_elmnt_cur (p_budget_version_id IN per_budget_versions.budget_version_id%TYPE) IS

44: SELECT *
45: FROM per_budget_versions
46: WHERE budget_id = p_budget_id;
47:
48: CURSOR per_budget_elmnt_cur (p_budget_version_id IN per_budget_versions.budget_version_id%TYPE) IS
49: SELECT *
50: FROM per_budget_elements
51: WHERE budget_version_id = p_budget_version_id;
52:

Line 63: l_per_budget_ver_rec per_budget_versions%ROWTYPE;

59: l_proc varchar2(72) := g_package||'extract_data';
60: l_per_budget_rec per_budgets%ROWTYPE;
61: l_budget_id pqh_budgets.budget_id%TYPE;
62: l_tot_budget_val per_budget_values.value%TYPE;
63: l_per_budget_ver_rec per_budget_versions%ROWTYPE;
64: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
65: l_per_budget_elmnt_rec per_budget_elements%ROWTYPE;
66: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
67: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;

Line 317: per_budget_versions ver

313: (
314: SELECT val.time_period_id
315: FROM per_budget_values val,
316: per_budget_elements ele,
317: per_budget_versions ver
318: WHERE val.budget_element_id = ele.budget_element_id
319: AND ele.budget_version_id = ver.budget_version_id
320: AND ver.budget_id = p_per_budgets_rec.budget_id
321: );

Line 341: per_budget_versions ver

337: FROM per_budget_values
338: WHERE budget_element_id IN
339: ( SELECT ele.budget_element_id
340: FROM per_budget_elements ele,
341: per_budget_versions ver
342: WHERE ele.budget_version_id = ver.budget_version_id
343: AND ver.budget_id = p_per_budgets_rec.budget_id
344: );
345:

Line 449: p_per_budget_ver_rec IN per_budget_versions%ROWTYPE,

445: --------------------------------------------------------------------------------------------------------------
446:
447: PROCEDURE populate_budget_versions
448: (
449: p_per_budget_ver_rec IN per_budget_versions%ROWTYPE,
450: p_budget_id IN pqh_budgets.budget_id%TYPE,
451: p_budget_version_id_o OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
452: )
453: IS

Line 1151: -- table_route_id for per_budget_versions

1147: OPEN csr_table_route (p_table_alias => 'P_BGT');
1148: FETCH csr_table_route INTO g_table_route_id_p_bgt;
1149: CLOSE csr_table_route;
1150:
1151: -- table_route_id for per_budget_versions
1152: OPEN csr_table_route (p_table_alias => 'P_BVR');
1153: FETCH csr_table_route INTO g_table_route_id_p_bvr;
1154: CLOSE csr_table_route;
1155:

Line 1256: p_budget_version_id IN per_budget_versions.budget_version_id%TYPE,

1252:
1253: --------------------------------------------------------------------------------------------------------------
1254: PROCEDURE set_p_bvr_log_context
1255: (
1256: p_budget_version_id IN per_budget_versions.budget_version_id%TYPE,
1257: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1258: ) IS
1259: /*
1260: This procedure will set the log_context at per budgets level

Line 1264: l_bdg_ver_number per_budget_versions.version_number%TYPE;

1260: This procedure will set the log_context at per budgets level
1261: */
1262:
1263: l_proc varchar2(72) := g_package||'set_p_bvr_log_context';
1264: l_bdg_ver_number per_budget_versions.version_number%TYPE;
1265:
1266: CURSOR bdg_ver_csr IS
1267: SELECT version_number
1268: FROM per_budget_versions

Line 1268: FROM per_budget_versions

1264: l_bdg_ver_number per_budget_versions.version_number%TYPE;
1265:
1266: CURSOR bdg_ver_csr IS
1267: SELECT version_number
1268: FROM per_budget_versions
1269: WHERE budget_version_id = p_budget_version_id;
1270:
1271: BEGIN
1272:

Line 1514: FROM per_budget_versions

1510: SELECT COUNT(budget_element_id)
1511: FROM per_budget_elements
1512: WHERE budget_version_id IN
1513: ( SELECT budget_version_id
1514: FROM per_budget_versions
1515: WHERE budget_id = p_per_budgets_rec.budget_id
1516: );
1517:
1518: CURSOR cnt_values IS

Line 1526: FROM per_budget_versions

1522: ( SELECT budget_element_id
1523: FROM per_budget_elements
1524: WHERE budget_version_id IN
1525: ( SELECT budget_version_id
1526: FROM per_budget_versions
1527: WHERE budget_id = p_per_budgets_rec.budget_id
1528: )
1529: );
1530: