114:
115: ELSE
116:
117: select count(*) into l_oper_resource
118: from wip_operation_resources
119: where wip_entity_id = p_wip_entity_id
120: and organization_id = p_organization_id
121: and operation_seq_num = p_operation_seq_num
122: and resource_seq_num = p_resource_seq_num;
131: l_request_id,
132: l_program_application_id,
133: l_program_id,
134: l_program_update_date
135: FROM WIP_OPERATION_RESOURCES
136: WHERE wip_entity_id = p_wip_entity_id
137: AND organization_id = p_organization_id
138: AND operation_seq_num = p_operation_seq_num
139: AND resource_seq_num = p_resource_seq_num;