DBA Data[Home] [Help]

APPS.EAM_RES_INST_DEFAULT_PVT dependencies on WIP_OPERATION_RESOURCES

Line 57: from wip_operation_resources where

53: p_eam_res_inst_rec.operation_seq_num is not null AND
54: p_eam_res_inst_rec.resource_seq_num is not null
55: THEN
56: select start_date into x_eam_res_inst_rec.start_date
57: from wip_operation_resources where
58: wip_entity_id = p_eam_res_inst_rec.wip_entity_id
59: and organization_id = p_eam_res_inst_rec.organization_id
60: and operation_seq_num = p_eam_res_inst_rec.operation_seq_num
61: and resource_seq_num = p_eam_res_inst_rec.resource_seq_num;

Line 73: from wip_operation_resources where

69: p_eam_res_inst_rec.operation_seq_num is not null AND
70: p_eam_res_inst_rec.resource_seq_num is not null
71: THEN
72: select completion_date into x_eam_res_inst_rec.completion_date
73: from wip_operation_resources where
74: wip_entity_id = p_eam_res_inst_rec.wip_entity_id
75: and organization_id = p_eam_res_inst_rec.organization_id
76: and operation_seq_num = p_eam_res_inst_rec.operation_seq_num
77: and resource_seq_num = p_eam_res_inst_rec.resource_seq_num;