APPS.PA_FP_ELEMENTS_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 3806: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;

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

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

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

Line 3827: ,pa_proj_element_versions pelm

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