DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on CST_ACTIVITIES

Line 3615: from wip_operation_resources wor,cst_activities ca

3611: -- Modified for Bug 16528843.
3612: begin
3613: select wor.basis_type, wor.standard_rate_flag, wor.uom_code,ca.activity_id, ca.activity
3614: into l_basis_type, l_standard_rate_flag, l_primary_uom, l_activity_id, l_activity_name
3615: from wip_operation_resources wor,cst_activities ca
3616: where wor.wip_entity_id = p_wip_entity_id
3617: and wor.operation_seq_num = p_operation_seq_num
3618: and wor.resource_seq_num = l_resource_seq_num -- p_resource_seq_num Bug 13481688
3619: and wor.resource_id = p_resource_id

Line 3628: from bom_resources br,cst_activities ca

3624: exception
3625: when no_data_found then
3626: select br.default_basis_type, br.standard_rate_flag, br.unit_of_measure,ca.activity_id, ca.activity
3627: into l_basis_type, l_standard_rate_flag, l_primary_uom,l_activity_id, l_activity_name
3628: from bom_resources br,cst_activities ca
3629: where br.resource_id = p_resource_id
3630: and br.default_activity_id = ca.activity_id (+)
3631: and nvl(ca.disable_date(+),sysdate+1) > sysdate
3632: and (ca.organization_id is null or ca.organization_id = p_organization_id);