APPS.PA_FP_ELEMENTS_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 3808: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;

3804: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3805: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3806: /*Bug # 3622551 --Added some parameters */
3807:
3808: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;
3809: l_task_id_tmp_tbl SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
3810:
3811:
3812: /*Bug # 3622551 -- Added a join to the cursor to get the value of wbs_element_version_id*/

Line 3814: ,c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE) IS

3810:
3811:
3812: /*Bug # 3622551 -- Added a join to the cursor to get the value of wbs_element_version_id*/
3813: CURSOR res_assign_cur(c_version_id NUMBER
3814: ,c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE) IS
3815: select distinct system_reference1 task_id
3816: ,system_reference2 resource_list_member_id
3817: ,system_reference3 CBS_ELEMENT_ID -- Added for CBS 16598322
3818: ,system_reference4 unit_of_measure

Line 3830: ,pa_proj_element_versions pelm

3826: -- ,null projfunc_burd_cost
3827: -- ,null projfunc_revenue
3828: -- ,null quantity
3829: from pa_fp_rollup_tmp rollup
3830: ,pa_proj_element_versions pelm
3831: where not exists
3832: (
3833: select pra.resource_assignment_id
3834: from pa_resource_assignments pra