APPS.PA_PROCESS_CI_LINES_PKG dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 123: and pevs.element_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(c_project_id);

119: and pev.proj_element_id = c_task_id
120: and pev.parent_structure_version_id = pevs.element_version_id
121: --and pevs.CURRENT_WORKING_FLAG = 'Y';
122: -- gboomina modified for bug 9714622 to fetch correct element version id
123: and pevs.element_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(c_project_id);
124:
125: cursor get_task_details(c_project_id number, c_task_id number) is
126: select task_number
127: from pa_tasks

Line 676: and pevs.element_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(c_proj_id);

672: and pev.proj_element_id=c_task_id
673: and pev.parent_structure_version_id=pevs.element_version_id
674: --and pevs.CURRENT_WORKING_FLAG='Y';
675: -- gboomina modified for bug 9714622 to fetch correct element version id
676: and pevs.element_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(c_proj_id);
677:
678:
679: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
680: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 859: and pevs.element_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(c_proj_id);

855: and pev.proj_element_id=c_task_id
856: and pev.parent_structure_version_id=pevs.element_version_id
857: -- and pevs.CURRENT_WORKING_FLAG='Y';
858: -- gboomina modified for bug 9714622 to fetch correct element version id
859: and pevs.element_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(c_proj_id);
860:
861:
862:
863: l_api_name CONSTANT varchar2(30) := 'CI.insert_planning_trx';