APPS.EAM_OTL_TIMECARD_PUB dependencies on BOM_DEPARTMENTS

Line 482: from bom_departments

478: if (l_charge_department is not null) then
479:
480: select distinct department_code
481: into l_charge_department_code
482: from bom_departments
483: where organization_id = l_organization_id
484: and department_id = l_charge_department;
485:
486: end if;

Line 1942: bom_departments where

1938: end if;
1939:
1940: if l_dept_id <> -9999 and l_org_id <> -9999 and l_dept_id is not null and l_org_id is not null then
1941: select department_code into l_dept_name from
1942: bom_departments where
1943: department_id = l_dept_id
1944: and organization_id = l_org_id;
1945: end if;
1946:

Line 1950: bom_departments where

1946:
1947:
1948: if l_charge_dept <> -9999 and l_org_id <> -9999 and l_charge_dept is not null and l_org_id is not null then
1949: select department_code into l_charge_dept_name from
1950: bom_departments where
1951: department_id = l_charge_dept
1952: and organization_id = l_org_id;
1953: end if;
1954:

Line 2162: bom_departments bd,

2158: to_char(bdri.department_id) as department_id,
2159: to_char(ppf.person_id) as person_id,
2160: bdri.resource_id as resource_id
2161: from bom_dept_res_instances bdri,
2162: bom_departments bd,
2163: bom_resource_employees bre,
2164: per_people_f ppf
2165: where bdri.instance_id = bre.instance_id
2166: and ppf.person_id = bre.person_id

Line 2178: bom_departments bd,

2174: to_char(bdr.department_id) as department_id,
2175: to_char(ppf.person_id) as person_id,
2176: bdri.resource_id as resource_id
2177: from bom_dept_res_instances bdri,
2178: bom_departments bd,
2179: bom_resource_employees bre,
2180: bom_department_resources bdr,
2181: per_people_f ppf
2182: where bdri.instance_id = bre.instance_id