APPS.CSE_COST_COLLECTOR dependencies on HR_ALL_ORGANIZATION_UNITS

Line 147: l_org_name hr_all_organization_units.name%TYPE;

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

Line 179: FROM hr_all_organization_units ho, hr_all_organization_units hoc

175: l_pa_interface_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type ;
176:
177: CURSOR c_Business_Group_cur( c_org_id NUMBER ) IS
178: SELECT ho.name
179: FROM hr_all_organization_units ho, hr_all_organization_units hoc
180: WHERE hoc.organization_id = c_org_id
181: AND ho.organization_id = hoc.business_group_id ;
182:
183: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;

Line 479: FROM hr_all_organization_units ho, hr_all_organization_units hoc

475: AND proj.project_id = task.project_id ;
476:
477: CURSOR c_Business_Group_cur( c_org_id NUMBER ) IS
478: SELECT ho.name
479: FROM hr_all_organization_units ho, hr_all_organization_units hoc
480: WHERE hoc.organization_id = c_org_id
481: AND ho.organization_id = hoc.business_group_id ;
482: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;
483: