APPS.EAM_OTL_TIMECARD_PUB dependencies on BOM_DEPARTMENTS

Line 481: from bom_departments

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

Line 1935: bom_departments where

1931: end if;
1932:
1933: 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
1934: select department_code into l_dept_name from
1935: bom_departments where
1936: department_id = l_dept_id
1937: and organization_id = l_org_id;
1938: end if;
1939:

Line 1943: bom_departments where

1939:
1940:
1941: 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
1942: select department_code into l_charge_dept_name from
1943: bom_departments where
1944: department_id = l_charge_dept
1945: and organization_id = l_org_id;
1946: end if;
1947:

Line 2155: bom_departments bd,

2151: to_char(bdri.department_id) as department_id,
2152: to_char(ppf.person_id) as person_id,
2153: bdri.resource_id as resource_id
2154: from bom_dept_res_instances bdri,
2155: bom_departments bd,
2156: bom_resource_employees bre,
2157: per_people_f ppf
2158: where bdri.instance_id = bre.instance_id
2159: and ppf.person_id = bre.person_id

Line 2171: bom_departments bd,

2167: to_char(bdr.department_id) as department_id,
2168: to_char(ppf.person_id) as person_id,
2169: bdri.resource_id as resource_id
2170: from bom_dept_res_instances bdri,
2171: bom_departments bd,
2172: bom_resource_employees bre,
2173: bom_department_resources bdr,
2174: per_people_f ppf
2175: where bdri.instance_id = bre.instance_id