APPS.CSE_COST_COLLECTOR dependencies on HR_ALL_ORGANIZATION_UNITS

Line 160: l_org_name hr_all_organization_units.name%TYPE;

156: CURSOR c_costing IS
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;

Line 192: FROM hr_all_organization_units ho, hr_all_organization_units hoc

188: l_pa_interface_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type ;
189:
190: CURSOR c_Business_Group_cur( c_org_id NUMBER ) IS
191: SELECT ho.name
192: FROM hr_all_organization_units ho, hr_all_organization_units hoc
193: WHERE hoc.organization_id = c_org_id
194: AND ho.organization_id = hoc.business_group_id ;
195:
196: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;

Line 492: FROM hr_all_organization_units ho, hr_all_organization_units hoc

488: AND proj.project_id = task.project_id ;
489:
490: CURSOR c_Business_Group_cur( c_org_id NUMBER ) IS
491: SELECT ho.name
492: FROM hr_all_organization_units ho, hr_all_organization_units hoc
493: WHERE hoc.organization_id = c_org_id
494: AND ho.organization_id = hoc.business_group_id ;
495: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;
496: