APPS.PA_PROCESS_CI_LINES_PKG dependencies on PA_TASKS

Line 127: from pa_tasks

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
128: where project_id = c_project_id
129: and task_id = c_task_id;
130:
131: cursor get_resource_assignment_id(c_bv_Id NUMBER,

Line 659: from pa_resource_assignments pra, pa_proj_elements ppe, pa_tasks pt,

655: c_task_id number,
656: c_rlmi_id number,
657: c_currency_code varchar2) is
658: select pra.RESOURCE_ASSIGNMENT_ID, ppe.ELEMENT_NUMBER, ppe.NAME
659: from pa_resource_assignments pra, pa_proj_elements ppe, pa_tasks pt,
660: pa_resource_asgn_curr prc
661: WHERE pra.budget_version_id = c_bvId
662: and pra.task_id = c_task_id
663: and pra.RESOURCE_LIST_MEMBER_ID = c_rlmi_id