APPS.CSE_COST_COLLECTOR dependencies on PA_PROJECTS_ALL

Line 122: FROM pa_projects_all

118: WHERE hr.organization_id = l_exp_org_id;
119:
120: CURSOR proj_number_cur (l_source_project_id IN NUMBER) IS
121: SELECT segment1
122: FROM pa_projects_all
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

Line 148: l_project_number pa_projects_all.segment1%TYPE;

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

Line 453: pa_projects_all proj,

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