DBA Data[Home] [Help]

APPS.WIP_TIME_ENTRY_PUB dependencies on BOM_DEPARTMENT_RESOURCES

Line 838: bom_department_resources bdr

834: if p_dep_id is not null then
835: select count(1)
836: into l_count
837: from bom_resource_employees bre,
838: bom_department_resources bdr
839: where bdr.department_id = p_dep_id
840: and bdr.resource_id = p_res_id
841: and bdr.resource_id = bre.resource_id
842: and bre.organization_id = p_org_id

Line 936: from bom_department_resources bdr,

932: l_count number;
933: begin
934: select count(1)
935: into l_count
936: from bom_department_resources bdr,
937: bom_departments bd
938: where bdr.department_id= bd.department_id
939: and bd.organization_id = p_org_id
940: and bd.department_id = p_dep_id