APPS.CSE_COST_COLLECTOR dependencies on PA_PROJECTS_ALL

Line 135: FROM pa_projects_all

131: WHERE hr.organization_id = l_exp_org_id;
132:
133: CURSOR proj_number_cur (l_source_project_id IN NUMBER) IS
134: SELECT segment1
135: FROM pa_projects_all
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

Line 161: l_project_number pa_projects_all.segment1%TYPE;

157: SELECT NVL(FND_PROFILE.VALUE('CSE_EIB_COSTING_USED'),'Y')
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 ;

Line 466: pa_projects_all proj,

462: FROM pa_expenditure_items_all item,
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)