DBA Data[Home] [Help]

APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_RESOURCE_EMPLOYEES

Line 71: from bom_resource_employees brem

67: and (wor.start_date > wjdi.start_date
68: or wor.completion_date < wjdi.completion_date))
69: or (p_resource_type = 2 and
70: exists (select 1
71: from bom_resource_employees brem
72: where brem.organization_id = p_organization_id
73: and brem.instance_id = p_instance_id
74: and (brem.effective_start_date > wjdi.start_date
75: or brem.effective_end_date < wjdi.completion_date))));

Line 121: from bom_resource_employees brem

117: and (wor.start_date > wjdi.start_date
118: or wor.completion_date < wjdi.completion_date))
119: or (p_resource_type = 2 and
120: exists (select 1
121: from bom_resource_employees brem
122: where brem.organization_id = p_organization_id
123: and brem.instance_id = p_instance_id
124: and (brem.effective_start_date > wjdi.start_date
125: or brem.effective_end_date < wjdi.completion_date))));