DBA Data[Home] [Help]

APPS.WIP_TIME_ENTRY_PUB dependencies on BOM_DEPARTMENT_RESOURCES

Line 770: bom_department_resources bdr

766: if p_dep_id is not null then
767: select count(1)
768: into l_count
769: from bom_resource_employees bre,
770: bom_department_resources bdr
771: where bdr.department_id = p_dep_id
772: and bdr.resource_id = p_res_id
773: and bdr.resource_id = bre.resource_id
774: and bre.organization_id = p_org_id

Line 868: from bom_department_resources bdr,

864: l_count number;
865: begin
866: select count(1)
867: into l_count
868: from bom_department_resources bdr,
869: bom_departments bd
870: where bdr.department_id= bd.department_id
871: and bd.organization_id = p_org_id
872: and bd.department_id = p_dep_id