APPS.CSE_COST_COLLECTOR dependencies on PA_TASKS

Line 140: FROM pa_tasks task

136: WHERE project_id = l_source_project_id;
137:
138: CURSOR task_number_cur (l_source_task_id IN NUMBER, l_source_project_id IN NUMBER) IS
139: SELECT task_number
140: FROM pa_tasks task
141: WHERE task_id = l_source_task_id
142: AND project_id = l_source_project_id;
143:
144: CURSOR item_name_cur (p_item_id IN NUMBER, p_organization_id IN NUMBER) IS

Line 162: l_task_number pa_tasks.task_number%TYPE;

158: FROM sys.dual;
159:
160: l_org_name hr_all_organization_units.name%TYPE;
161: l_project_number pa_projects_all.segment1%TYPE;
162: l_task_number pa_tasks.task_number%TYPE;
163: l_eib_trackable_flag VARCHAR2(5);
164: l_item_name mtl_system_items.segment1%TYPE;
165: l_exp_item_date DATE ;
166: l_exp_end_date DATE ;

Line 467: pa_tasks task,

463: pa_cost_distribution_lines_all dist,
464: pa_expenditure_groups_all grp,
465: pa_expenditures_all exp,
466: pa_projects_all proj,
467: pa_tasks task,
468: hr_organization_units org
469: WHERE org.organization_id = NVL(item.override_to_organization_id,
470: exp.incurred_by_organization_id)
471: AND NVL(dist.reversed_flag, 'N') <> 'Y'