APPS.PA_FP_WEBADI_PKG dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 8124: l_new_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;

8120: -- counter variables
8121: i INTEGER;
8122:
8123: -- variables used to call add_planning_transactions
8124: l_new_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;
8125: l_new_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8126: l_new_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8127: l_new_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8128: l_new_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8699: FROM pa_proj_element_versions pev

8695: -- selecting element_version_id
8696: BEGIN
8697: SELECT pev.element_version_id
8698: INTO l_new_elem_ver_id
8699: FROM pa_proj_element_versions pev
8700: WHERE pev.proj_element_id = l_task_id_tbl(i)
8701: AND pev.parent_structure_version_id = p_version_info_rec.x_project_structure_version_id;
8702: --log1('----- STAGE PBL5-------');
8703: EXCEPTION

Line 11843: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,

11839: */
11840: --This Cursor is used to get Resource Assignment information associated with the budget version.
11841: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,
11842: c_project_id pa_projects_all.project_id%TYPE,
11843: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,
11844: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
11845: IS
11846: SELECT pra.resource_assignment_id resource_assignment_id,
11847: nvl(pe.name,ppa.long_name) task_name,

Line 11880: pa_proj_element_versions pev,

11876: FROM pa_resource_assignments pra,
11877: pa_resource_asgn_curr prac,
11878: pa_fp_txn_currencies pftc,
11879: pa_proj_elements pe,
11880: pa_proj_element_versions pev,
11881: pa_resource_list_members prlm,
11882: pa_lookups uom,
11883: pa_spread_curves_tl psc,
11884: cst_cost_types cct,