APPS.CSE_COST_COLLECTOR dependencies on PA_TASKS

Line 127: FROM pa_tasks task

123: WHERE project_id = l_source_project_id;
124:
125: CURSOR task_number_cur (l_source_task_id IN NUMBER, l_source_project_id IN NUMBER) IS
126: SELECT task_number
127: FROM pa_tasks task
128: WHERE task_id = l_source_task_id
129: AND project_id = l_source_project_id;
130:
131: CURSOR item_name_cur (p_item_id IN NUMBER, p_organization_id IN NUMBER) IS

Line 149: l_task_number pa_tasks.task_number%TYPE;

145: FROM sys.dual;
146:
147: l_org_name hr_all_organization_units.name%TYPE;
148: l_project_number pa_projects_all.segment1%TYPE;
149: l_task_number pa_tasks.task_number%TYPE;
150: l_eib_trackable_flag VARCHAR2(5);
151: l_item_name mtl_system_items.segment1%TYPE;
152: l_exp_item_date DATE ;
153: l_exp_end_date DATE ;

Line 454: pa_tasks task,

450: pa_cost_distribution_lines_all dist,
451: pa_expenditure_groups_all grp,
452: pa_expenditures_all exp,
453: pa_projects_all proj,
454: pa_tasks task,
455: hr_organization_units org
456: WHERE org.organization_id = NVL(item.override_to_organization_id,
457: exp.incurred_by_organization_id)
458: AND NVL(dist.reversed_flag, 'N') <> 'Y'